All Forums Database
openbox 4 posts Joined 12/13
22 Jun 2016
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,

tomnolan 594 posts Joined 01/08
22 Jun 2016
select * from MyTable where scan_tm = time '11:22:33'

 

You must sign in to leave a comment.