[Download-List] date

[Minatra, Pat H.]

Debbie:

You can ALSO do:

 

FMT(CONVERT(" ","",OCONV(BIRTH.DATE,"DYMD4,2,2")),"L#8")

 

Which is what I use as I had a need for CCYYMMDD format to import to
another system which is what this is.

 

HTH and have a GREAT day!

 

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin-Simmons University 
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698
-------------------------
The mission of Hardin-Simmons University is to be a community dedicated
to providing excellence in education enlightened by Christian faith and
values.
-------------------------
PRIVILEGED AND CONFIDENTIAL NOTICE: The information contained in this
e-mail may be confidential and/or privileged. This e-mail is intended to
be reviewed initially by only the individual named above. If the reader
of this e-mail is not the intended recipient or a representative of the
intended recipient, you are hereby notified that any review,
dissemination or copying of this e-mail, or the information contained
herein, is prohibited. If you have received this e-mail in error, notify
the above sender, send the message back and then delete it.
-------------------------
Thank you for your assistance. Hardin-Simmons University; 2200
Hickory/HSU Box 16040; Abilene, TX  79698; 325.670.1000
------------------------- 

 

From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Spitzner,
Eric
Sent: Thursday, July 19, 2007 7:13 AM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] date

 

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/a4069b8a/attachment.html>