The date output format may vary depending on the Timestamp type and the timestamp_output_format being used, you can consult here.
Code Example
Input Code:
IN -> PostgreSQL_01.sql
CREATETABLEtable1 ( dt_update timestamp without time zoneDEFAULT clock_timestamp());
Output Code:
OUT -> PostgreSQL_01.sql
CREATETABLEtable1 ( dt_update TIMESTAMP_NTZ DEFAULTCAST( --** SSC-FDM-PG0004 - THE DATE OUTPUT FORMAT MAY VARY DEPENDING ON THE TIMESTAMP TYPE AND THE TIMESTAMP_OUTPUT_FORMAT BEING USED. **
CURRENT_TIMESTAMP() AS TIMESTAMP_NTZ))COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "postgresql", "convertedOn": "09/17/2024" }}';
Samples
Example with CREATE TABLE.
Input Code:
IN -> PostgreSQL_02.sql
CREATETABLEsample2 ( platform_id integerNOT NULL, dt_update timestamp with time zoneDEFAULT clock_timestamp());insert into postgres.public.sample2 (platform_id) values (1);select*, clock_timestamp() from postgres.public.sample2;
CREATETABLEsample2 ( platform_id integerNOT NULL, dt_update TIMESTAMP_TZ DEFAULTCAST(--** SSC-FDM-PG0004 - THE DATE OUTPUT FORMAT MAY VARY DEPENDING ON THE TIMESTAMP TYPE AND THE TIMESTAMP_OUTPUT_FORMAT BEING USED. **
CURRENT_TIMESTAMP() AS TIMESTAMP_TZ));insert into postgres.public.sample2 (platform_id) values (1);ALTERSESSIONSET timestamp_output_format ='YYYY-MM-DD HH24:MI:SS.FF';select*,CURRENT_TIMESTAMP(3)frompostgres.public.sample2;