GETDATE() equivelant in Oracle

Use SYSDATE in Oracle:

SELECT SYSDATE FROM dual;
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') FROM dual;

f8aec0e8-efba-44d4-abcd-5ed731ccb4a7|0|.0

Categories: Databases

Posted by wizgod on Thursday, August 26, 2010 8:14 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (1) | Post RSS RSS comment feed

MS SQL TOP equivelant in OracleOriginal Post: http://bytes.com/topic/oracle/answers/631642-top-10-rows#post2501910 For top row ju...Recursive query in Oracle using CONNECT BY clauseThis page explains the hierarchical query using the (start with) connect by clause in an Oracle SQL ...Get the database version in Oracle.Simple and effective: SELECT * FROM v$version WHERE BANNER LIKE 'Oracle%'

Comments

Friday, February 03, 2012 12:19 PM

Your post caught my eye. Thanks for sharing this important information.

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

Byte My Data