Using SQL
CONVERT(VARCHAR,CONVERT(DATETIME,'20060523'),101)
Using CF
Mid('20060523',5,2) & '/' & Right('20060523',2) & '/' &
Left('20060523',4)
-----Original Message-----
From: Loathe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 11:10 AM
To: CF-Talk
Subject: RE: any idea how to
Date format?
Left, mid, right?
-----Original Message-----
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 12:05 PM
To: CF-Talk
Subject: any idea how to
Convert 20060523
Into 5/23/2006
I'm at a loss.
Thanks in advance
sas
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
http://www.sstwebworks.com
<http://www.linkedin.com/in/sstwebworks>
http://www.linkedin.com/in/sstwebworks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285713
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
