[Download-List] date

[Spitzner, Eric]

Debbie,
 
You simply combine two conversions: "CONVERT(OCONV(somedate,
'D4-MDY'),'-','')" will convert "somedate" in internal date format to
month-day-year format with four-digit year and hyphen delimiters, then
conver the hyphens to nulls.
 
HTH
Eric Spitzner, CDP (eric.spitzner at quinnipiac.edu)
Senior Programmer/Analyst
Quinnipiac University; Hamden, Connecticut
Sun V440; Solaris 2.9; UniData 6.0.9
Colleague 17.0.14 and Benefactor 5.1 

________________________________



Anyone know how to output a date MMDDYYYY without any separators?

 

Thanks!

 

Debbie Moyers

***********************************

Business Analyst

Lincoln Memorial University

6965 Cumberland Gap Pkwy

Harrogate, TN 37752

(423) 869-6469

debra.moyers at lmunet.edu

***********************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20070719/5fb6ab6d/attachment.html>