Skip to Content
0
May 25, 2020 at 12:58 PM

Issue with date/time format settings

286 Views

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