Re: [Q] Frusturating SQL question

Posted in 1996

John Callaway — 6 Mar 1996 21:31:45 GMT — source: Informix-list mailing list archive (1991-1998)

In article <DnI1x9.CIG@cix.compulink.co.uk>, onlinedbc@cix.compulink.co.uk says... > >Try > where lastmod = CURRENT (YEAR TO MINUTE) > It should work! Today is only used with Date fields not datetime! > > My favorite, because it takes less typing :-), is -- where lastmod > TODAY Since TODAY is a date, it resolves to TODAY 00:00. If you run it after midnight, change it to -- where lastmod between (TODAY-1 and TODAY) John Callaway Bath Iron Works All opinions expressed herein are my own and should be piped through sanity.check