Home » SQL & PL/SQL » SQL & PL/SQL » sysdate
sysdate [message #18937] Thu, 21 February 2002 18:44 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
How do u select only the date, only the time, only the day using 'sysdate' and dual?
Re: sysdate [message #18939 is a reply to message #18937] Thu, 21 February 2002 19:07 Go to previous messageGo to next message
maithili arjunwadkar
Messages: 2
Registered: February 2002
Junior Member
'select sydate,to_char(sysdate,'hh:mi:ss') ,to_char(sysdate,'Day') from dual'
Re: sysdate [message #18941 is a reply to message #18937] Thu, 21 February 2002 19:33 Go to previous message
maithili arjunwadkar
Messages: 2
Registered: February 2002
Junior Member
SQL> select to_char(sysdate,'dd||hh:mm::ss||day') from dual;

TO_CHAR(SYSDATE,'DD||H
----------------------
22ぺ:02::15&#124friday
Previous Topic: Re: not equal- != or <>
Next Topic: Order of index columns
Goto Forum:
  


Current Time: Sun Sep 19 11:11:29 CDT 2021