Home » SQL & PL/SQL » SQL & PL/SQL » sysdate (oracle 10g)  () 1 Vote
sysdate [message #338513] Tue, 05 August 2008 05:02 Go to next message
Messages: 6
Registered: July 2008
Junior Member

Im using the statement
SELECT sysdate FROM dual;

It returns the date only not the time, i thought sysdate was supposed to return date and time?

Thanks in advance

Re: sysdate [message #338545 is a reply to message #338513] Tue, 05 August 2008 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Re: sysdate [message #338546 is a reply to message #338513] Tue, 05 August 2008 05:41 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not unless you use a proper date format.
Previous Topic: Trigger
Next Topic: Use of REGEXP_LIKE
Goto Forum:

Current Time: Wed Aug 23 01:25:11 CDT 2017

Total time taken to generate the page: 0.09484 seconds