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