Re: How to compare Time with Integer?

---- you wrote: > How to compare Time with Integer? > > I have an Integervalue which show me the seconds of a Day. > On the other side i have a Time ( hour to second). > How can i compare these values like : > > Select * From X > Where ((time) as seconds) as Integer > Integervalue> > or > Select * From X > Where time > ((Integervalue) as Time) Well Dude, you can try this: select * from X where time > datetime(00:00:00) hour to second + Integervalue units second AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com