Re: select * from calls where timestamp > ?????

Or you can try select * from calls where timestamp > '2007-06-07 00:00:00' The format is hh:mm:ss where hh is 24 hour format from 00 - 23 and mm is 60 minute format from 00 - 59 and ss is 60 second format from 00 - 59 Assuming timestamp was created as DATETIME YEAR TO SECOND. I'm using version 10.00.FC6 on HPUX. Bevis >>> Superboer <superboer7@t-online.de> 6/11/2007 8:45 AM >>> > select * from calls where timestamp > ( date("06/07/2007") :: datetime year to second) + 7 units hour + 42 units minute + 34 units second .... in case i mix up am and pm, i usually do.... > select * from calls where timestamp > ( date("06/07/2007") :: datetime year to second) + 19 units hour + 42 units minute + 34 units second or write an spl which takes a string and returns an int which represents the nr of seconds for hour minute sec. Superboer. On 11 jun, 15:11, cj <ChrisJo...@MailShack.com> wrote: > timestamp is a datetime year to second field. I need to specify a > time like 6/7/2007 7:42:34am. How can I accomplish this? > > The closest I've been able to get is > > select * from calls where timestamp > date("06/07/2007")> > but I need the time too. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list