Hi Everyone,
I am trying to put a group by clause in my query and the field I want to
group by is a date/time field in my table. But because almost every
record has different time, even there are several records existed for
the same day, they won't group. For example, one record is "5/4/00
3:15:00 PM" and the other is "5/4/00 3:40:00 PM". They won't group
because of the time difference. What's the function in SQL that
extracts date value from a date/time field? I used "datevalue" but it
didn't help? Any idea? Thanks.
--
Nathan Chen
(208)-426-8470
Computer Control Systems, Inc.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
