MySQL Forums
Forum List  »  Newbie

Quick Question On Sorting VARCHAR date field?
Posted by: Jeff Smith
Date: August 02, 2015 11:49AM

Hi guys...

Here's the time/date that is entered into a varchar column. I'd like to be able to sort by the day rather than the time of the entry. What would the sql look like to do that?

Here's an example: 08:52:22 Jul 25, 2015 PDT

Options: ReplyQuote


Subject
Written By
Posted
Quick Question On Sorting VARCHAR date field?
August 02, 2015 11:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.