TIMESTAMP with T as separator (ISO 8601)

softdev1

For TIMESTAMP and TIMESTAMPTZ fields, the Vertica documentation specifies the following formats:

 

2004-10-19 10:23:54

2004-10-19 10:23:54+02

 

Does Vertica officially support input in ISO 8601 format with 'T' as separator? It appears to work via SQL console, but I'd like to know if there are any issues, and if it will work correctly for all input methods.

Example with 'T' separator:

 

2004-10-19T10:23:54

2004-10-19T10:23:54+02

2004-10-19T10:23:54+05:30

2004-10-19T10:23:54.123+05:30

 

BoMBaY

You can specify a format when you insert data to a table or select data from a table.

 

Example:

 

dbadmin=> create table t1 (c1 timestamp);
CREATE TABLE

 

dbadmin=> insert into t1 values (to_timestamp('2004-10-19T10:23:54', 'yyyy-mm-dd HH24:mi:ss'));
 OUTPUT
--------
      1
(1 row)

 

dbadmin=> commit;
COMMIT

dbadmin=> select * from t1;
         c1         
---------------------
 2004-10-19 10:23:54
(1 row)

 

dbadmin=> select to_char(c1, 'yyyy-mm-ddThh24:mi:ss') from t1;
       to_char      
---------------------
 2004-10-19T10:23:54

(1 row)