OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sysdate

Thu, 21 February 2002 18:44

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?

Thu, 21 February 2002 19:07

maithili arjunwadkar
Messages: 2
Registered: February 2002

Junior Member

'select sydate,to_char(sysdate,'hh:mi:ss') ,to_char(sysdate,'Day') from dual'

Thu, 21 February 2002 19:33

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: Wed Apr 17 19:31:29 CDT 2024