1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
/* postgres can not */
select cast("1970-01-01" as date),cast(cast("1970-01-01" as date) as string);
select cast("2000-04-05" as date),cast(cast("2000-04-05" as date) as string);
select cast("2100-02-29" as date),cast(cast("2100-02-29" as date) as string);
select cast("2100-03-01" as date),cast(cast("2100-03-01" as date) as string);
select cast("2000-04-05T06:07:08Z" as datetime),cast(cast("2000-04-05T06:07:08Z" as datetime) as string);
select cast("2000-04-05T06:07:08Z" as timestamp),cast(cast("2000-04-05T06:07:08Z" as timestamp) as string);
select cast("2000-04-05T06:07:08.9Z" as timestamp),cast(cast("2000-04-05T06:07:08.9Z" as timestamp) as string);
select cast("2000-04-05T06:07:08.000009Z" as timestamp),cast(cast("2000-04-05T06:07:08.000009Z" as timestamp) as string);
select cast("P" as interval),cast(cast("P" as interval) as string);
select cast("P1D" as interval),cast(cast("P1D" as interval) as string);
select cast("-P1D" as interval),cast(cast("-P1D" as interval) as string);
select cast("PT2H" as interval),cast(cast("PT2H" as interval) as string);
select cast("PT2H3M" as interval),cast(cast("PT2H3M" as interval) as string);
select cast("PT3M" as interval),cast(cast("PT3M" as interval) as string);
select cast("PT3M4S" as interval),cast(cast("PT3M4S" as interval) as string);
select cast("PT4S" as interval),cast(cast("PT4S" as interval) as string);
select cast("PT0S" as interval),cast(cast("PT0S" as interval) as string);
select cast("PT4.5S" as interval),cast(cast("PT4.5S" as interval) as string);
select cast("PT4.000005S" as interval),cast(cast("PT4.000005S" as interval) as string);
select cast("P1DT2H3M4.5S" as interval),cast(cast("P1DT2H3M4.5S" as interval) as string);
select cast("2105-12-31" as date),cast(cast("2105-12-31" as date) as string);
select cast("2106-01-01" as date),cast(cast("2106-01-01" as date) as string);
select cast("2105-12-31T23:59:59Z" as datetime),cast(cast("2105-12-31T23:59:59Z" as datetime) as string);
select cast("2106-01-01T00:00:00Z" as datetime),cast(cast("2106-01-01T00:00:00Z" as datetime) as string);
select cast("2105-12-31T23:59:59.999999Z" as timestamp),cast(cast("2105-12-31T23:59:59.999999Z" as timestamp) as string);
select cast("2106-01-01T00:00:00.000000Z" as timestamp),cast(cast("2106-01-01T00:00:00.000000Z" as timestamp) as string);
select cast("P49672DT23H59M59.999999S" as interval),cast(cast("P49672DT23H59M59.999999S" as interval) as string);
select cast("P49673D" as interval),cast(cast("P49673D" as interval) as string);
|
