Home » SQL & PL/SQL » SQL & PL/SQL » Time not being displayed
Time not being displayed [message #19032] Tue, 26 February 2002 15:48 Go to next message
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

Report message to a moderator

Re: Time not being displayed [message #19034 is a reply to message #19032] Tue, 26 February 2002 16:46 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
Should use this

select to_char(sysdate,'dd/mm/yy hh:mi') from dual

Hope this will help you. Thanks

Report message to a moderator

Re: Time not being displayed [message #19041 is a reply to message #19032] Tue, 26 February 2002 21:02 Go to previous message
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;

Report message to a moderator

Previous Topic: Re: difference : primary key and unique not null
Next Topic: About Composite Key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 02:56:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.