CURRENT DATE

Compatibility

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'

1.

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

SELECT CAST(CURRENT_DATE AS DATE),wk FROM totp Submit SQLrestore default

result

See also

• CURRENT_TIMESTAMP function
• +(date) function

Language:Project:Language policy	English  • Deutsch