Error when change length/set in datetime2 column

1 posts
riookesekali's profile image riookesekali posted 3 years ago in Running SQL scripts Permalink

First of all thank you for your hard work for this amazing software. But I've been getting error whenever changing length in datetime2 column.

SQL Error (102): Incorrect syntax near 'DATETIME2'

I am using SQL server database. I think maybe there is something wrong in generated query?

ALTER TABLE "dbo"."Data Durasi" ALTER COLUMN "start_min" "start_min" DATETIME2(0) NULL DEFAULT NULL; / SQL Error (102): Incorrect syntax near 'DATETIME2'. /

Thanks for your help!

Please login to leave a reply, or register at first.