Re: getting sys date and database name thru SQL
From: Lee Mayhew <lmayhew_at_ionet.net>
Date: 1995/04/26
Message-ID: <3nlltp$52q_at_ionews.ionet.net>#1/1
04/26/1995
Date: 1995/04/26
Message-ID: <3nlltp$52q_at_ionews.ionet.net>#1/1
In article <3nlkn3$ldd_at_news.ed.ray.com>, swong_at_ED.RAY.COM says...
>
>Does anyone know how to get the system date and the database name using
a SQL
>statement? Thanks.
>
>S.W.
>
For the system data you can use SYSDATE like:
select to_char(SYSDATE, 'MM/DD/YYYY') system_date from dual;
SYSTEM_DATE
04/26/1995
Lee Received on Wed Apr 26 1995 - 00:00:00 CEST