Revision 916 org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/resources/org/gvsig/oracle/dal/operations/sql/date.sql
| date.sql | ||
|---|---|---|
| 2 | 2 |
-- Date SQL |
| 3 | 3 |
|
| 4 | 4 |
SELECT |
| 5 |
"P1"."test"."ID", "P1"."test"."Byte", "P1"."test"."Bool1", "P1"."test"."Long",
|
|
| 6 |
"P1"."test"."Timestamp", "P1"."test"."Date", "P1"."test"."Time", "P1"."test"."Bool2",
|
|
| 7 |
"P1"."test"."String", "P1"."test"."Bool3", "P1"."test"."Double",
|
|
| 8 |
"P1"."test"."Bool4", "P1"."test"."Float", "P1"."test"."Bool5", "P1"."test"."Decimal",
|
|
| 9 |
NVL2(("P1"."test"."Geometry"),("P1"."test"."Geometry").Get_WKB(),NULL)
|
|
| 10 |
FROM "P1"."test"
|
|
| 5 |
"P1"."TEST"."ID", "P1"."TEST"."Byte", "P1"."TEST"."Bool1", "P1"."TEST"."Long",
|
|
| 6 |
"P1"."TEST"."Timestamp", "P1"."TEST"."Date", "P1"."TEST"."Time", "P1"."TEST"."Bool2",
|
|
| 7 |
"P1"."TEST"."String", "P1"."TEST"."Bool3", "P1"."TEST"."Double",
|
|
| 8 |
"P1"."TEST"."Bool4", "P1"."TEST"."Float", "P1"."TEST"."Bool5", "P1"."TEST"."Decimal",
|
|
| 9 |
NVL2(("P1"."TEST"."Geometry"),("P1"."TEST"."Geometry").Get_WKB(),NULL)
|
|
| 10 |
FROM "P1"."TEST"
|
|
| 11 | 11 |
WHERE ( |
| 12 | 12 |
(( |
| 13 |
(( ("P1"."test"."Time") > (TIMESTAMP '1970-01-01 01:02:03') ))
|
|
| 13 |
(( ("P1"."TEST"."Time") > (TIMESTAMP '1970-01-01 01:02:03') ))
|
|
| 14 | 14 |
AND |
| 15 |
(( ("P1"."test"."Time") < (TIMESTAMP '1970-01-01 20:52:55') ))
|
|
| 15 |
(( ("P1"."TEST"."Time") < (TIMESTAMP '1970-01-01 20:52:55') ))
|
|
| 16 | 16 |
)) |
| 17 | 17 |
OR |
| 18 | 18 |
(( |
| 19 |
(( ("P1"."test"."Date") > (DATE '2019-02-17') ))
|
|
| 19 |
(( ("P1"."TEST"."Date") > (DATE '2019-02-17') ))
|
|
| 20 | 20 |
AND |
| 21 |
(( ("P1"."test"."Date") < (DATE '2020-02-23') ))
|
|
| 21 |
(( ("P1"."TEST"."Date") < (DATE '2020-02-23') ))
|
|
| 22 | 22 |
)) |
| 23 |
) ORDER BY "P1"."test"."ID" ASC; |
|
| 23 |
) ORDER BY "P1"."TEST"."ID" ASC; |
|
Also available in: Unified diff