Re: [Q] Frusturating SQL question

Try where lastmod = CURRENT (YEAR TO MINUTE) It should work! Today is only used with Date fields not datetime! > 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 Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc