Hello,
Trying to set the date/time format for the session, using SET 'DATE_FORMAT' and SET 'TIMESTAMP_FORMAT' as documented...
What am I doing wrong here?
hdbsql test1=> create table tab1 ( pkey int, crea date ); 0 rows affected (overall time 453.262 msec; server time 10.121 msec) hdbsql test1=> SET 'DATE_FORMAT' = 'DD / MM / YYYY'; 0 rows affected (overall time 379.044 msec; server time 221 usec) hdbsql test1=> select * from tab1; PKEY,CREA 101,"2020-12-24" 1 row selected (overall time 1052.995 msec; server time 370 usec) hdbsql test1=> insert into tab1 values ( 102, '23 / 05 / 2019' ); * 303: invalid DATE, TIME or TIMESTAMP value: Error while parsing 23 / 05 / 2019 as DATE at function __typecast__() (at pos 31) (field:CREA) SQLSTATE: 22007 hdbsql test1=> create table tab2 ( pkey int, crea timestamp ); 0 rows affected (overall time 1315.746 msec; server time 9409 usec) hdbsql test1=> SET 'TIMESTAMP_FORMAT' = 'DD/MM/YYYY HH:MI:SS'; 0 rows affected (overall time 584.132 msec; server time 214 usec) hdbsql test1=> insert into tab2 values ( 101, '24/12/2020 23:45:56'); * 303: invalid DATE, TIME or TIMESTAMP value: Error while parsing 24/12/2020 23:45:56 as TIMESTAMP at function __typecast__() (at pos 31) (field:CREA) SQLSTATE: 22007