Re: [Q] Frusturating SQL question

Saqib Mausoof wrote: > > 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> How about where date(lastmod) = TODAY? > This does not work, obviously. But what does work? Any ideas? > > I would be gald of any help. > Saqib -- -------------------------------------------------------------------------------John Prideaux e-mail: alastl@ix.netcom.com Phone: (217)839-2121 Aladdin Steel, Inc. Fax: (217)839-4327 -------------------------------------------------------------------------------