Re: SQL Q: how to select current time?

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Tue, 25 Aug 1998 08:32:20 +0200
Message-ID: <35E25A74.9690F3AE_at_fs-edv.de>


m_van_basten_at_hotmail.com wrote:
>
> Selecting SysDate from dual only gives the date. So how to select
> current
> time? And how to select date and time together?
>
...
It's just a question of formats:
Time only: select to_char(sysdate, 'HH24:MI') from dual; Date & Time: select to_char(sysdate, 'MM/DD/YYYY HH24:MI') from dual;

Hope it helps

Arnold Received on Tue Aug 25 1998 - 08:32:20 CEST

Original text of this message