dateformat(signup_datetime, "mm/dd/yyyy")
Or use any mask you choose for the mm/dd/yyyy part. Just run your query and
grab the fields, then do the mask in CF when displaying the data.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.
-----Original Message-----
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:09 PM
To: CF-Talk
Subject: (Easy SQL)
I have a member table which contains
userid, signup_datetime
I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime
== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the
time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
the day?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
