Supports TIMESTAMP_MS, TIMESTAMP_S and TIMESTAMP_NS types

[killme2008]

What problem does the new feature solve?

They are just the alias for the timestamp types with different units.

Hope to run the following SQL:

SELECT DATE '1992-01-01'::TIMESTAMP_MS;

What does the feature do?

Timestamp types alias with different units.

Implementation challenges

No response

[waynexia]

what does MS mean? Millisecond or Microsecond

[killme2008]

what does MS mean? Millisecond or Microsecond

Millisecond

[waynexia]

Then how to express MicroSecond? Or we can define it as TimestampMilli, TimestampMicro, TimestampSecond, TimestampMillisecond (duplicate some for convenient)

[killme2008]

Then how to express MicroSecond? Or we can define it as TimestampMilli, TimestampMicro, TimestampSecond, TimestampMillisecond (duplicate some for convenient)

These names look too long. Maybe we can use timstamp_micros for MicroSecond.

[Gump9]

I want to have a try,any example?which file should i change?

[waynexia]

Also support this grammar:

SELECT TIMESTAMP ‘2020-01-01 01:23:45.12345678’::TIMESTAMP(9);
Error: 3000(PlanQuery), This feature is not implemented: Unsupported SQL type Timestamp(Some(9), None)

[Gump9]

Also support this grammar:

SELECT TIMESTAMP ‘2020-01-01 01:23:45.12345678’::TIMESTAMP(9);
Error: 3000(PlanQuery), This feature is not implemented: Unsupported SQL type Timestamp(Some(9), None)

OK,give me some time please,a little busy lately😰

[killme2008]

@Gump9 hi, are you still working on this issue? We want to support these types in v0.4

[Gump9]

@Gump9 hi, are you still working on this issue? We want to support these types in v0.4

Sorry, I must finished the school project in the past month, and I haven't had enough time to focus on this issue.🤕️I will try other issue soon,my bad