Re: getting sys date and database name thru SQL

Karl Penney (aa651_at_cfn.cs.dal.ca) wrote:
: swong_at_ED.RAY.COM wrote:
: : Does anyone know how to get the system date and the database name using a SQL
: : statement? Thanks.
 

: To get the date, SELECT SYSDATE FROM DUAL
 

: --
: Karl Penney |~~~~~~| _/^\_ |~~~~~~|
: DMR Group, Halifax, NS | | _/\_\ /_/\_ | |
: aa651_at_cfn.cs.dal.ca | | >___________< | |
: 74203.673_at_compuserve.com |______| | |______|

On a V7 database

SELECT SYSDATE, NAME FROM V$DATABASE;

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer