I am working on integrating databases from both MySQL and Postgres into SQL Server. My data migration from Postgres to SQL Server is failing because of the default value expression in Postgres.
This is the default value expression:
Does anyone know what the SQL Server equivalent is? I managed to successfully migrate the data using using
date_part('epoch'::text, now())=1 though I do not know if this is the real equivalent?
Can someone please tell me if this is in fact the SQL Server equivalent?