SELECT SYSDATE FROM DUAL;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Richard Edwards" <richard_at_not.my.address.com> wrote in message
news:iJRY8.73$8Y.832_at_news.uk.colt.net...
> All,
> I have an Oracle database that contains stock prices.
> I would like to pull the data for the current day into Excel. So far I
can
> download the data and using MS Query manually specify the current date in
> the criteria field.
> Is there anyway I can automate this? Is there a 'system date' variable?
>
> Thanks.
>
>
> Richard
>
>
Received on Tue Jul 16 2002 - 05:02:40 CDT
