Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Date and Time Asc and desc
Rajasekhar G
Jun 7 2017 3:00 AM
205
Reply
hi
i have one table which contains date column(mm/dd/yyyy) and Time(hh:mm:ss t) column separately.both are in varchar data type now how can i get in asc order or desc order like as follows
mm/dd/yyyy and hh:mm:ss t
05/27/2017 and 04:33:45 PM
05/27/2017 and 04:32:00 am
04/01/2017 and 05:30:00 PM
03/01/2017 and 10:30:00 Am
please refer following
please give the solution.
i need changes in varchar data type only not in datetime data type.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
what is sp_lock?
What use of Cross apply?