CURRENT DATE
From SQLZoo
CURRENT_DATE | ||
---|---|---|
Engine | OK | Alternative |
ingres | Yes | You must cast when using DBD::Ingres |
mysql | Yes | |
oracle | Yes | |
postgres | Yes | |
sqlserver | No | CONVERT(CHAR(10),CURRENT_TIMESTAMP,126) |
CURRENT_DATE
CURRENT_DATE returns today's date.
CURRENT_DATE -> '2006-12-31'
SELECT CURRENT_TIMESTAMP, whn
FROM eclipse
SELECT CAST(CURRENT_DATE AS DATE),wk
FROM gisq.totp
SELECT CAST(CURRENT_DATE AS DATE),wk
FROM totp
See also
Language: | English • Deutsch |
---|