alisator comments

Repositories
Issues
Comments

Results 2 comments of


                                            alisator

Support preferred postgres data type of timestamp with time zone

Hello I encoutered the same issue, we use timestamptz. Error message below. ``` Caused by: org.postgresql.util.PSQLException: ERROR: column "df_created" is of type timestamp with time zone but expression is of...

Support preferred postgres data type of timestamp with time zone

> While we wait for an official solution, a temporary fix is as follows: > > `CREATE OR REPLACE FUNCTION varchar_to_timestamp (varchar) RETURNS timestamptz AS $$ SELECT to_timestamp($1, 'YYYY-MM-DD"T"HH24:MI:SS.USZ') $$...