Time not being displayed [message #19032] |
Tue, 26 February 2002 15:48 |
Indu
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
select to_date(sysdate,'dd/mm/yy hh:mi') from dual
I don't see the time being displayed here. Any setting in the database to be checked, for the time to be displayed ?
Thanks,
Indu
|
|
|
|
Re: Time not being displayed [message #19041 is a reply to message #19032] |
Tue, 26 February 2002 21:02 |
K. Prakash babu
Messages: 46 Registered: July 2001
|
Member |
|
|
To display the date in customized format. We will have to convert the date into character format. So use TO_CHAR to display the date in the required format.
EX:- SELECT TO_CHAR(SYSDATE, 'DD/MM/YY HH:MI') FROM DUAL;
|
|
|