How to query specific time

Database

How to query specific time

Hi,

I'm just new in TD, need help on how to select a specific time? 

the columns look like this:

     store_id INTEGER NOT NULL,

     scan_dt DATE FORMAT 'MM/DD/YYYY' NOT NULL,

     scan_tm TIME(0) FORMAT 'hh:mi:ss' NOT NULL,

1 REPLY
Teradata Employee

Re: How to query specific time

select * from MyTable where scan_tm = time '11:22:33'