>>dateformat(signup_datetime, "mm/dd/yyyy")
This post reminded me of something I needed to confirm....
I'm about to start development on a Unix platform, and I've been told to
make sure my ColdFusion functions and Application.cfm were properly
formatted in regards to case sensitivity.
Is this correct?
Erika
"Twixt optimist and pessimist, The difference is droll; The optimist sees
the doughnut, The pessimist, the hole." - McLandburgh Wilson
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 4:26 PM
To: CF-Talk
Subject: RE: (Easy SQL)
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
