Query earliest time from given date

[Lurc]

Hi all,

In a sample table, it has fields date(date/time), time(text), cardno(text),
and has following data.

Date Time CardNo
2004-05-13 19:16:00 71B08C
2004-05-13 19:17:00 71B08C
2004-05-13 19:31:00 71B08C

How can I use sql query to retrieve the earliest time, here is 19:16:00,
from a given date?

Thanks.

 

[Miha Markic [MVP C#]]

Why are you storing time separately in first place?

 

[Lurc]

Hi Miha,

The table structure is not designed by us, it comes with original hardware
provider. Now we only want to select some interesting data out for analysis.