seabro Posted March 3, 2009 Share Posted March 3, 2009 Hi, I have a field in my database where the entries are like: 2009-02-16 14:05:28 2009-02-16 14:13:10 2009-02-16 14:08:29 2009-02-16 14:18:13 2009-02-16 14:39:11 2009-02-16 14:39:38 2009-02-16 14:40:23 2009-02-16 14:38:17 2009-02-16 14:41:21 2009-02-16 14:44:53 2009-02-16 14:44:59 The records are not all the same day but how can query to only show distinct days? I have tried SELECT DISTINCT but that doesn't work because they pretty much are distince with the times in them. Your help apprciated. Thanks. seabro Quote Link to comment Share on other sites More sharing options...
premiso Posted March 3, 2009 Share Posted March 3, 2009 SELECT DISTINCT DATE_FORMAT('%Y-%m-%d', `datecol`) FROM `table_name` WHERE `somecol` = 'someval' DATE_FORMAT Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.