getdate() for now()
getdate(-1) for yesterday and so on
----- Original Message -----
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 9:08 PM
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
