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 Link to comment https://forums.phpfreaks.com/topic/147743-sql-query-question/ 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 Link to comment https://forums.phpfreaks.com/topic/147743-sql-query-question/#findComment-775548 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.