peterjc Posted July 31, 2008 Share Posted July 31, 2008 at database, there is a field call time to store this value: 2008-7-30 13:16:10 So, at the sql statement, i use: SELECT id FROM tablename where time='$today'; The $today is like 2008-7-30 13 (without the second) but because the time stored contain second(2008-7-30 13:16:10), so how to use mysql to cast the time from 2008-7-30 13:16:10 to 2008-7-30. become without second? Thank. Link to comment https://forums.phpfreaks.com/topic/117453-solved-sql-cast-datetime-to-date/ Share on other sites More sharing options...
Barand Posted July 31, 2008 Share Posted July 31, 2008 DATE(datetimecol) Link to comment https://forums.phpfreaks.com/topic/117453-solved-sql-cast-datetime-to-date/#findComment-604275 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.