Re: [Q] Frusturating SQL question

Saqib, I haven't tried this myself, but with datetime columns, I think the correct syntax is: where lastmod = CURRENT (YEAR TO MINUTE) HTH, Richard. ----------------------------------------------------------------- | _________ | Richard Thomas | | / /_______| | r.thomas@csl.gov.uk | | / /__/ | | | /_/ | TRIGGER happy ;-) | | | | ----------------------------------------------------------------- } } I hope someone can help me out of this frustaration. I have a } tbale in Informix 5.01 that hold information for visitors to our } site. I need to print out a simple report which shows the number } of visitors and their time of arrival at midnight everday. A } simple cron job unloads my query into an ascii file and with a } little awk manipulation I print the file to the remote site. } } Unfortunately, I can't get my SIMPLE query to work. My date } column is LASTMOD (DATETIME YEAR TO MINUTE) and I need to get } data for just one day. My query is } } Select lname, fname, vendor, status, lastmod } from visitors } where lastmod = TODAY (YEAR TO MINUTE) } order by 3,2,1 } } This does not work, obviously. But what does work? Any ideas? } } I would be gald of any help. } Saqib }