Lyleyboy Posted March 26, 2008 Share Posted March 26, 2008 Hi, I have a simple table that has a date field in it. The date is formatted at UTC i.e. 1206518328 Is there a way I can for example query select * from table where date (SOME FORMAT) = January Storing the date in UTC seems the best option but I'm not sure how to work with it. Thanks Link to comment https://forums.phpfreaks.com/topic/97932-mysql-date-query/ Share on other sites More sharing options...
zenag Posted March 26, 2008 Share Posted March 26, 2008 <? echo date ('YmdHiZ');?> utc format for date.. Link to comment https://forums.phpfreaks.com/topic/97932-mysql-date-query/#findComment-501043 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.