svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / date.sql @ 46402
History | View | Annotate | Download (437 Bytes)
1 | 45472 | jjdelcerro | |
---|---|---|---|
2 | -- Date SQL
|
||
3 | |||
4 | -- Simple
|
||
5 | SELECT
|
||
6 | "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", |
||
7 | "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", |
||
8 | NVL2("Geometry",ST_AsBinary("Geometry"),NULL) |
||
9 | FROM "PUBLIC"."test" |
||
10 | WHERE ((
|
||
11 | ("Time" > TIME '01:02:03') AND |
||
12 | ("Time" < TIME '20:52:55') |
||
13 | ) OR (
|
||
14 | ("Date" > DATE '2019-02-17') AND |
||
15 | ("Date" < DATE '2020-02-23') |
||
16 | 46402 | jjdelcerro | )) ORDER BY "ID" ASC; |