Home » SQL & PL/SQL » SQL & PL/SQL » how to retrieve sysdate in oracle?senthil
how to retrieve sysdate in oracle?senthil [message #210068] Tue, 19 December 2006 03:43 Go to next message
senthildurga
Messages: 9
Registered: December 2006
Junior Member
how to retrieve sysdate in oracle?senthil
Re: how to retrieve sysdate in oracle?senthil [message #210069 is a reply to message #210068] Tue, 19 December 2006 03:45 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi

since when are you working in Oracle?

bye Ashu
Re: how to retrieve sysdate in oracle?senthil [message #210070 is a reply to message #210068] Tue, 19 December 2006 03:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It's a built in function called SYSDATE.
Re: how to retrieve sysdate in oracle?senthil [message #210225 is a reply to message #210068] Tue, 19 December 2006 22:24 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

addition of others.


sql>select sysdate from dual;
---------------------
sql>select current_date from dual;

regards
Taj
Previous Topic: UPDATE ERRO ORA-00933
Next Topic: Merge the Result of two Queries
Goto Forum:
  


Current Time: Sun Dec 11 08:29:16 CST 2016

Total time taken to generate the page: 0.10639 seconds