search

sqlparser / sql2xml

Turn SQL query into XML structure for further processing.
Apache License 2.0
4 stars 1 forks source link

datatype: datetime type #62

Open sqlparser opened 10 years ago

sqlparser commented 10 years ago 
create table t1(
 f1 date,
 f2 time,
 f3 time(1),
 f4 time(2) with time zone,
 f5 time(2) without time zone,
 f6 timestamp,
 f7 timestamp(1),
 f8 timestamp(2) with time zone,
 f9 timestamp(2) without time zone
);
cnfree commented 10 years ago

f2 time's data type returns generic_t, but not time_t.

cnfree commented 10 years ago

f3 time(1), f4 time(2) with time zone, f5 time(2) without time zone, f9 timestamp(2) without time zone

gsp can't parse them correctly.

cnfree commented 10 years ago

Implemented the other data types.