New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Incorrect parsing of default sysdatetime() function #177

Open

shubham-yb opened this issue Mar 28, 2023 · 0 comments

shubham-yb commented Mar 28, 2023

Hi Team,
If we have a date time type column with a default value ex:

ALTER TABLE [dbo].[AAFILE] ADD  CONSTRAINT [DF_AAFILE_created_on]  DEFAULT (sysdatetime()) FOR [created_on]

The function sysdatetime() gets parsed as is which is not supported by PG ex:

ALTER TABLE "public"."aafile" ALTER COLUMN "created_on" SET DEFAULT sysdatetime();

If we could convert it to now(), the PG equivalent, the error can be avoided.

Thank You for your help.

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment