gvsig-oracle / org.gvsig.oracle / trunk / org.gvsig.oracle / org.gvsig.oracle.provider / src / test / resources / org / gvsig / oracle / dal / operations / sql / date.sql @ 916
History | View | Annotate | Download (820 Bytes)
| 1 | 178 | fdiaz | |
|---|---|---|---|
| 2 | -- Date SQL
|
||
| 3 | |||
| 4 | SELECT
|
||
| 5 | 916 | jjdelcerro | "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 | 178 | fdiaz | WHERE (
|
| 12 | (( |
||
| 13 | 916 | jjdelcerro | (( ("P1"."TEST"."Time") > (TIMESTAMP '1970-01-01 01:02:03') )) |
| 14 | 178 | fdiaz | AND
|
| 15 | 916 | jjdelcerro | (( ("P1"."TEST"."Time") < (TIMESTAMP '1970-01-01 20:52:55') )) |
| 16 | 178 | fdiaz | )) |
| 17 | OR
|
||
| 18 | (( |
||
| 19 | 916 | jjdelcerro | (( ("P1"."TEST"."Date") > (DATE '2019-02-17') )) |
| 20 | 178 | fdiaz | AND
|
| 21 | 916 | jjdelcerro | (( ("P1"."TEST"."Date") < (DATE '2020-02-23') )) |
| 22 | 178 | fdiaz | )) |
| 23 | 916 | jjdelcerro | ) ORDER BY "P1"."TEST"."ID" ASC; |