Difference between SYSDATE and TO

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Wed, 29 Oct 2003 20:43:41 GMT
Message-ID: <1EVnb.5230$_36.47992857@news-text.cableinet.net>

Hi,

Can anyone explain what the difference between these 2 queries is and why one returns 0 rows?

SELECT Count(*) FROM EVENTSTREAM WHERE TYPE = 11 AND (TS BETWEEN TO_DATE('28-OCT-03') AND TO_DATE('29-OCT-03')); COUNT(*)

447

and

SELECT Count(*) FROM EVENTSTREAM WHERE TYPE = 11 AND (TS BETWEEN SYSDATE AND SYSDATE-1); COUNT(*)

and just to check SYSDATE

SELECT SYSDATE FROM DUAL; SYSDATE

29-OCT-03 DESC EVENTSTREAM;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------


----

 TS                                        NOT NULL DATE
 TYPE                                      NOT NULL NUMBER(2)
 PERMID                                             VARCHAR2(40)
 SESSID                                             VARCHAR2(40)
 LODGECODE                                          VARCHAR2(10)
 CUSTCODE                                           VARCHAR2(15)
 BOOKCODE                                           VARCHAR2(15)
 BOOKTRACKNO                                        NUMBER(9)
 CAMPAIGNCODE                                       VARCHAR2(30)

This is on 9.2.0.4 and 8.1.5 they both return the same.

thanks

Tom Received on Wed Oct 29 2003 - 14:43:41 CST

Difference between SYSDATE and TO_DATE