Re: sysdate & date columns

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Thu, 27 Jan 2000 01:40:06 GMT
Message-ID: <8EC7C9C9Fdlm@206.141.192.241>

fumi_at_tpts5.seed.net.tw (fumi) wrote in <86di8r$alt$6_at_news.seed.net.tw>:
>dave mausner <dmausner_at_ameritech.x.net> wrote in message
news:8EC16734Bdlm_at_206.141.192.241...
>> select ... from T where date1 between trunc(sysdate)
>> and trunc(sysdate+1)-1/24/60/60
>This works in Oracle.
>But, if the database is DB2 or SQL Server, this way is wrong.

what did you expect, doofus: this is comp.databases.ORACLE.server! --
dave mausner Received on Wed Jan 26 2000 - 19:40:06 CST