Re: Dates Help!!

clarket_at_voicenet.com (Penn Thomas) wrote:

>I need help with dates and SQL. When I try to write a 'select'
>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
>
>

I don't think you need to use DUAL in order to get SYSDATE. Just use it with the table you're selecting.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!