Retrieving dates from Oracle Server
From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/10/01
Message-ID: <44n78l$213_at_dingo.cc.uq.oz.au>#1/1
Date: 1995/10/01
Message-ID: <44n78l$213_at_dingo.cc.uq.oz.au>#1/1
Joel Nylund <joel_nylund_at_mail.amsinc.com> wrote:
>Does anyone know of a way to get the date from the Oracle Server using SQL?
>I am looking for something similar to "select getDate()" in sybase.
>thanks in advance
>Joel
RTFM select sysdate from dual;
-----------------------------\ooOoo/----------------------------------- Gordon Hooker MACS PCP ,--_|\ 25 Clarke Street, Ripley, Queensland, 4306, Australia / \ gordonh_at_acslink.net.au \_.--._/ mobile: 018883835 phone: 61-7-2889716 V -----------------------------------------------------------------------It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Sun Oct 01 1995 - 00:00:00 CET