sptrsn Posted April 13, 2012 Share Posted April 13, 2012 I have separate date and time fields in my table. I need a where clause that will check if these two fields together are greater than now. This is an auction item where the end date and time are in these two fields and don't want to include the record if the auction has expired for this item. I've tried scads of different things. With the searching I've done... it seems like it should be something like this.... and DATE_ADD(n.sale_date, INTERVAL n.sale_time HOUR_SECOND) > now() Additionally, once this base clause works, I need to figure out how to add a 3 hour server time adjustment. Appreciate any input. Link to comment https://forums.phpfreaks.com/topic/260895-need-a-little-help-with-a-date-and-time-field-where-clause/ Share on other sites More sharing options...
sptrsn Posted April 13, 2012 Author Share Posted April 13, 2012 I got it. and concat(sale_date,' ',sale_time) > now() Link to comment https://forums.phpfreaks.com/topic/260895-need-a-little-help-with-a-date-and-time-field-where-clause/#findComment-1337204 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.