Need a little help with a date and time field where clause

[sptrsn]

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.

[sptrsn]

I got it.

and  concat(sale_date,' ',sale_time) > now()