[ start | index | login ]
start > snipsnap-index > SQL*PLUS > Oracle

Oracle

Created by mpecher. Last edited by mpecher, 6 years and 57 days ago. Viewed 509 times. #2
[diff] [history] [edit] [rdf]
labels
attachments

Getting date/time from Oracle

select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Current Time"
from dual;
>> Ref on getting format
no comments | post comment
see also:
SQL*PLUS snipsnap-index SQL*PLU... snipsnap-search

Menu:
Java & J2EE
Development
Books

Help:
Help FAQ
Formatting


< May 2012 >
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031


Logged in Users: (0)
… and a Guest.

Recently Changed


Disclaimer: Views and opinions are that of the individual author, and not that of Marand Custom Solutions. This site is an open forum for technical content, and the company accepts no liability for any content or view expressed.