Comparing DATE with TIMESTAMP fields possible ?

From: George Dainis <george.dainis_at_bluecorner.com>
Date: Wed, 9 Feb 2005 23:13:46 +0100
Message-ID: <cue1up$k5b$01$1@news.t-online.com>

In my database table there is a datetime column which can obviously contain a timestamp (in the format YYYY-MM-DD HH:MM:SS.NNN).

Now I want to get all those records which have a date of lets say 2005-02-03 regardsless of their time value.

Ok, I could do this by statement like

SELECT * FROM MYTAB WHERE MYDATE >= '2005-02-03 00:00:00.000' AND MYDATE <= '2005-02-03 23:59.59.999'

but this is rather inconvenient. I feel that there must be a shorter version like

SELECT * FROM MYTAB WHERE MYDATE = '2005-02-03 **:**:**.***' or a built-in fuction like:

SELECT * FROM MYTAB WHERE datepartonly(MYDATE) = '2005-02-03'

How does this work?

George Received on Wed Feb 09 2005 - 16:13:46 CST