Creating new tables

Database

Creating new tables

Hello, I am sorta new at Teradata and I am creating a new table and one of the fields needs to be a time field.
The query keeps kicking back stating that the format is incorrect.

CB_Time TIME FORMAT 'hh:mm:ss',

what am I missing. I want this fields as military time.
1 REPLY
Enthusiast

Re: Creating new tables

The format code in the minutes field should be 'mi' not 'mm':

create table test1 (a int, b time format 'hh:mi:ss');

insert into test1 values (1, current_time);

*** Insert completed. One row added.
*** Total elapsed time was 1 second.

select * from test1;

*** Query completed. One row found. 2 columns returned.
*** Total elapsed time was 1 second.

a b
----------- --------
1 23:53:25