Re: SQL Q: how to select current time?

From: m_van_basten_at_hotmail.com >>
[Quoted] Selecting SysDate from dual only gives the date. So how to select current time? <<

select to_char(sysdate,'format mask')
from sys.dual;

example:
to_char(sysdate,'YYYYDDD HH24:MI:SS') which would produce something like 1998200 19:00:20

See the SQL Manual for all the date mask formats.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Mon Aug 24 1998 - 00:00:00 CEST