Date and Time compare question

[ppohlmann]

Hello Gurus,

I have a table that holds one date field and one time field.
The formats are 2011-12-01 and the time field format is 22:55:01

I want to compare a string "2011-12-01 22:58:00" to the date and time field
of the table, without having to take the string apart.

SELECT * FROM usrteams where '2011-12-01 22:58:00' <= games.gamedate + games.cutofftime

This above does not seem to look right... any suggestions ?

Thanks in advance.
Peter

[peter_carlos]

You are comparing with two fields in the database with concatenation.
You should compare each field alone

SELECT * FROM usrteams where '2011-12-01' <= games.gamedate and  '22:58:00'  <= games.cutofftime

[ppohlmann]

thanks .. works great ..