CURRENT DATE/de
CURRENT_DATE | ||
---|---|---|
DBMS | OK | Alternative |
Ingres | Ja | Mit DBD::Ingres muss CAST verwendet werden. |
MySQL | Ja | |
Oracle | Ja | |
PostgreSQL | Ja | |
SQL Server | Nein | CONVERT(CHAR(10),CURRENT_TIMESTAMP,126) |
CURRENT_DATE
CURRENT_DATE liefert das aktuelle Systemdatum.
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
Siehe auch
Language: | [[:{{#invoke:String|sub|CURRENT DATE/de
|1 |Expression error: Unrecognised punctuation character "{".}}|English]] |
---|