DAY/de
Revision as of 18:06, 21 October 2012 by Peter (talk | contribs) (Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>DAY(d)</th></tr> <tr><td align='center'>'''DBMS'''</td><td align='...")
DAY(d) | ||
---|---|---|
DBMS | OK | Alternative |
Ingres | Nein | EXTRACT(DAY from d) |
MySQL | Ja | EXTRACT(DAY from d) |
Oracle | Nein | TO_CHAR(d,'DD') |
PostgreSQL | Nein | EXTRACT(DAY from d) |
SQL Server | Ja | DATEPART(DAY,d) |
DAY
Mit DAY wird der Tag aus einem Datumswert ermittelt.
DAY(d)
In diesem Beispiel wird der Tag aus dem whn
-Datum ermittelt.
SELECT EXTRACT(DAY from whn) AS v
,whn
,wht
FROM eclipse
SELECT EXTRACT(DAY from whn) AS v
,whn
,wht
FROM eclipse
SELECT TO_CHAR(whn,'DAY') AS v
,whn
,wht
FROM gisq.eclipse
SELECT DAY(whn) AS v
,whn
,wht
FROM eclipse
Siehe auch
Language: | [[:{{#invoke:String|sub|DAY/de
|1 |Expression error: Unrecognized punctuation character "{".}}|English]] |
---|