Substring(currentdate,1,2)||substring(currentdate,4,2)||substring(currentdat
e,7,4)

There are 10 types of people in the world, those that understand binary and
those that don't....


-----Original Message-----
From: Andrews, Daryl [mailto:[Email Address Removed]
Sent: Thursday, January 29, 2004 3:55 PM
To: LazyDBA.com Discussion
Subject: Date Styles

I'm trying to create a date string of MMDDYYYY. There is no standard
"style" that I can find for this. However, I can get MM/DD/YYYY,

CONVERT (CHAR(8),L.CURRENTDATE,101)

but can't seem to put the "replace" statement in the right place to pull out
the "/". Any ideas?

Thanks!

Daryl



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.573 / Virus Database: 363 - Release Date: 1/28/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.573 / Virus Database: 363 - Release Date: 1/28/2004


MS Sql Server LazyDBA home page