René's URL Explorer Experiment

Title: Incorrect parsing of default sysdatetime() function · Issue #177 · dalibo/sqlserver2pgsql · GitHub

Open Graph Title: Incorrect parsing of default sysdatetime() function · Issue #177 · dalibo/sqlserver2pgsql

X Title: Incorrect parsing of default sysdatetime() function · Issue #177 · dalibo/sqlserver2pgsql

Description: 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 supp...

Open Graph Description: 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 sysdateti...

X Description: 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 sysdateti...

Opengraph URL: https://github.com/dalibo/sqlserver2pgsql/issues/177

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Incorrect parsing of default sysdatetime() function","articleBody":"Hi Team,\r\nIf we have a date time type column with a default value ex:\r\n\r\n```\r\nALTER TABLE [dbo].[AAFILE] ADD  CONSTRAINT [DF_AAFILE_created_on]  DEFAULT (sysdatetime()) FOR [created_on]\r\n```\r\nThe function **sysdatetime()** gets parsed as is which is not supported by PG ex: \r\n```\r\nALTER TABLE \"public\".\"aafile\" ALTER COLUMN \"created_on\" SET DEFAULT sysdatetime();\r\n```\r\n\r\nIf we could convert it to **now()**, the PG equivalent, the error can be avoided.\r\n\r\nThank You for your help.","author":{"url":"https://github.com/shubham-yb","@type":"Person","name":"shubham-yb"},"datePublished":"2023-03-28T08:59:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/177/sqlserver2pgsql/issues/177"}

Links:

Viewport: width=device-width