current date

[specv]

How can I obtain the current date (the system date) in a query ?

Thanks

Phil

 

[karluk]

select sysdate from dual;

 

[tlbroadbent]

Select CURRENT_TIMESTAMP As CurrDate Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.