sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

INTERVAL support, date pseudo literals TIMESTAMP and TIME literals.

Open kchasapis opened this issue 7 months ago • 1 comments

The interval was not allowed to be a column data type. With this patch we add this support.

We add support for the pseudo literals CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_DATE.

Also, we add support for TIMESTAMP and TIME literals. The user can now explicitly set the type of the string value it follows with TIMESTAMP 'value' and TIME 'value.

DATE was already supported.

kchasapis avatar Jun 02 '25 21:06 kchasapis

Thank you for your contribution! Before I go into detail reviewing your changes, can you please add some unit tests?

Thanks for your message. I have added unit tests. Please, let me know if there is anything else needed from my side to get started in the review.

kchasapis avatar Jun 16 '25 22:06 kchasapis