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 @ 47787
History | View | Annotate | Download (778 Bytes)
1 | 45472 | jjdelcerro | |
---|---|---|---|
2 | -- Date SQL
|
||
3 | |||
4 | -- Simple
|
||
5 | SELECT
|
||
6 | 46505 | fdiaz | "PUBLIC"."test"."ID", "PUBLIC"."test"."Byte", "PUBLIC"."test"."Bool1", "PUBLIC"."test"."Long", |
7 | "PUBLIC"."test"."Timestamp", "PUBLIC"."test"."Date", "PUBLIC"."test"."Time", "PUBLIC"."test"."Bool2", |
||
8 | "PUBLIC"."test"."String", "PUBLIC"."test"."Bool3", "PUBLIC"."test"."Double", "PUBLIC"."test"."Bool4", |
||
9 | "PUBLIC"."test"."Float", "PUBLIC"."test"."Bool5", "PUBLIC"."test"."Decimal", |
||
10 | NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL) |
||
11 | FROM "PUBLIC"."test" |
||
12 | WHERE
|
||
13 | ((("PUBLIC"."test"."Time" > TIME '01:02:03') AND ("PUBLIC"."test"."Time" < TIME '20:52:55')) OR |
||
14 | (("PUBLIC"."test"."Date" > DATE '2019-02-17') AND ("PUBLIC"."test"."Date" < DATE '2020-02-23'))) |
||
15 | ORDER BY "PUBLIC"."test"."ID" ASC; |