Re: Dates Help!!
Date: 1996/07/03
Message-ID: <31da6bdb.1279532_at_n5.gbso.net>#1/1
clarket_at_voicenet.com (Penn Thomas) wrote:
>I need help with dates and SQL. When I try to write a 'select'
I don't think you need to use DUAL in order to get SYSDATE. Just use
it with the table you're selecting.
>statement which calls for the SysDate from 'DUAL' oracle tells me that DUAL
>does not exist, I had believed that 'DUAL' is preset table which can not be
>deleted in oracle.
>
>Also the SQL statement which I am trying to write calls, for the user to enter
>a date within a program and then for oracle to search for all data between the
>user's date, and theh 'SysDate', any help on how to write this is greatly
>appreciated.
>
>thanks
>clarke
>
>
--
Chuck Hamilton
chuckh_at_dvol.com
Never share a foxhole with anyone braver than yourself!
Received on Wed Jul 03 1996 - 00:00:00 CEST