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: 63911
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not unless you use a proper date format.
Previous Topic: How to use bankers' rounding in sql
Next Topic: Creating own Formulas
Goto Forum:

Current Time: Sun Oct 23 05:19:36 CDT 2016

Total time taken to generate the page: 0.19676 seconds