Revision 46505 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
date.sql | ||
---|---|---|
3 | 3 |
|
4 | 4 |
-- Simple |
5 | 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 |
)) ORDER BY "ID" ASC; |
|
6 |
"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; |
Also available in: Unified diff