TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rajasekhar G
NA
2
616
Date and Time Asc and desc
Jun 7 2017 3:00 AM
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.
Reply
Answers (
2
)
what is sp_lock?
What use of Cross apply?