Friday, March 20, 2015

Database:Get current date

This post for personal references

Oracle

Select sysdate from dual;
( I had learned this in first job)

SELECT TO_CHAR
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
     FROM DUAL;

NOW
-------------------
03-20-2015 09:45:51

MS Sql Server

select GETDATE()
SELECT {fn NOW()}

Ms Access

Select Date() from table1 (any ms access user table )

MySQL

SELECT NOW(),CURDATE(),CURTIME()

Sample result:
NOW()                         CURDATE() CURTIME()
2015-11-11 12:46:34 2015-11-11 12:45:34

SQLite

SELECT date('now');

DB2

SELECT current date FROM sysibm.sysdummy1
SELECT current time FROM sysibm.sysdummy1
SELECT current timestamp FROM sysibm.sysdummy1

PostgreSQL

SELECT CURRENT_TIME;
Result: 14:49:53.662522-05

SELECT CURRENT_DATE;
Result: 2015-03-23

SELECT CURRENT_TIMESTAMP;
Result: 2015-03-23 14:49:53.662522-05

SELECT CURRENT_TIMESTAMP(2);
Result: 2015-03-23 14:49:53.66-05

SELECT LOCALTIMESTAMP;

Result: 2015-03-23 14:49:53.662522

Sybase

select getdate()

Result: Mar 19 2015 12:45PM