Eine Einführung in
SQL
Get the current date and/or time
SQLite
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to SQLite
none
DB2
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to DB2
none
MS Access
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT Now(), Date(), Time() FROM nix
Specific to MS Access
none
PostgreSQL
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to PostgreSQL
none
Oracle
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT SYSDATE, SYSTIMESTAMP FROM nix
Specific to Oracle
none
MS SQL Server
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT GETDATE() FROM nix
Specific to MS SQL Server
none
MySQL
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to MySQL
none
Sybase
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT GETDATE() FROM nix
Specific to Sybase
none
Mimer SQL
SQL Standard specifies
CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME
. These are widely ignored :(
Execute set up
code
DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1)
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to Mimer SQL
none