See following example:
note: you will have to make use of CONVERT function.
Ex:
create table #t(code int, endtime varchar(500))

insert into #t select 1 ,'08:00:00' union all
select 2 ,'23:59:59' union all
select 3 ,'15:22:23'


select * from #t
where convert(datetime, endtime,108) > '15:00:00'

--
-Vishal

"JJ" <digi123 (AT) mail2me (DOT) com.au> wrote

Example Table:

Code EndTime
1 08:00:00
2 23:59:59
3 15:22:23

Why after " SELECT * from Table WHERE ( EndTime>'15:00:00' ) " query statement, it never return any result?!
Does the query statement needs more correction?!

------------------------------------------------------------------------------

Please help. MANY THANKS in advance
JJ

First, thank you for your reply.


No. Originally, the field 'EndTime' is already created in 'Datetime' table data type (not in varchar)


My problem is how to query for the right rows with eg. Endtime>'15:00:00'. I've tried with the SELECT statement.
But the returning result is - it doesn't return any thing at all ?! Couldn't we compare directly with 'datetime' field(without any CONVERT function) ? What have I done wrong....?

Please comments.

JJ



"Vishal Parkar" <vgparkar (AT) hotmail (DOT) com> wrote

See following example:
note: you will have to make use of CONVERT function.
Ex:
create table #t(code int, endtime varchar(500))

insert into #t select 1 ,'08:00:00' union all
select 2 ,'23:59:59' union all
select 3 ,'15:22:23'


select * from #t
where convert(datetime, endtime,108) > '15:00:00'

--
-Vishal

"JJ" <digi123 (AT) mail2me (DOT) com.au> wrote

Example Table:

Code EndTime
1 08:00:00
2 23:59:59
3 15:22:23

Why after " SELECT * from Table WHERE ( EndTime>'15:00:00' ) " query statement, it never return any result?!
Does the query statement needs more correction?!

----------------------------------------------------------------------------

Please help. MANY THANKS in advance
JJ