SnowflakeDocumentation Home

MSC-PG0004

The date output format may vary

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

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:

CREATE TABLE table1 (
    dt_update timestamp without time zone DEFAULT clock_timestamp()
    );

Output Code:

CREATE TABLE table1 (
    dt_update TIMESTAMP_NTZ DEFAULT
    /*** MSC-WARNING - MSC-PG0002 - THE DATE OUTPUT FORMAT MAY VARY DEPENDING ON THE TIMESTAMP TYPE AND THE TIMESTAMP_OUTPUT_FORMAT BEING USED. ***/
    CURRENT_TIMESTAMP() :: TIMESTAMP_NTZ
)

Samples

Example with CREATE TABLE.

Input Code:

CREATE TABLE sample2 (
    platform_id integer NOT NULL,
    dt_update timestamp with time zone DEFAULT clock_timestamp()
);
    
insert into postgres.public.sample2 (platform_id) values (1);
   
select *, clock_timestamp() from postgres.public.sample2;

Output Code:

platform_id|dt_update                    |clock_timestamp              |
-----------+-----------------------------+-----------------------------+
          1|2023-02-05 22:47:34.275 -0600|2023-02-05 23:16:15.754 -0600|

Example with SELECT with clock_timestamp().

Input Code

select clock_timestamp();

Output Code

clock_timestamp        |
-----------------------+
2023-02-05 23:24:13.740|

Recommendations

PreviousMSC-PG0003NextMSC-PG0005

Last updated