if u r using sql server then there is a date function called dateformat() it
gives date value from datetime so u need to give in action page while
retrieving the records dateformat(datefield,"YYYY/MM/DD")
nagesh
-----Original Message-----
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2000 11:57 AM
To: cftalk
Subject: How to extract date value?
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.
------------------------------------------------------------------------------
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.
