Here is the query I have written: select to_varchar(Date_column, 'HH:mm AM') The example output is 23:06 PM... How can I convert it to 11:06 PM? I am writing the query in Snowflake web UI.
Quote:AM , PM - Ante meridiem (am) / post meridiem (pm); for use with HH12.
MM
MI
select to_varchar(Date_column, 'HH12:MI AM')
select convert(varchar, Date_column, 114)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)