jeffg Posted March 16, 2008 Share Posted March 16, 2008 Seems like a silly question, but I have seen no actual examples... Can I always compare two DATE or DATETIME fields with normal comparison operators in an SQL query and be sure to get the expected result? Such as date1 >= date2 (where date1 is '2008-03-16' and date2 is '2008-05-12') should return false.What would happen if I compared a DATE field with a DATETIME field? Link to comment Share on other sites More sharing options...
justsomeguy Posted March 19, 2008 Share Posted March 19, 2008 As far as I know you can, it might vary by DBMS though. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.