SQL Date Conversion routines

[Guest.Visitor]

Is anyone aware of any data conversion routines in SQL that can be used to convert JD Edwards Julian dates to Conventional Date formats ? Thanks All...

[Guest.Visitor]

I have some old code in REXX... What are the JDE formats? bobh

[Guest.Visitor]

Do you mean to say that your users don't care for dates like 100001? ;-) I wondered when people would get past the brouhaha re Y2K compliance and see the problems with such a proprietary date format. Plus things like "Columbus sailed the ocean blue, in 1992..." Anyhow, I think you would have a great performance killer when trying to do the conversion in a straight SQL statement. PROBABLY the best way to go would be a user defined function that someone takes a good bit of care to optimize. Joe Sam Joe Sam Shirah - jshirah@attglobal.net Autumn Software - Consulting/Development/Outsourcing Just the JDBC FAQs: http://www.jguru.com/faq/JDBC Going International? http://www.jguru.com/faq/I18N

[Guest.Visitor]

Paul, The following assumes that the JDE dates are numeric 7.0 fields, and are in the format of YYYYDDD. <pre> Create View QTemp/DteView (DateFld) As Select Date(Digits(JulDte)) From filename</pre> Bill