View Full Version : SQL Date Conversion routines
01-01-1995, 02:00 AM
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...
07-08-2000, 10:57 AM
I have some old code in REXX... What are the JDE formats? bobh
07-09-2000, 10:35 PM
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 - email@example.com Autumn Software - Consulting/Development/Outsourcing Just the JDBC FAQs: http://www.jguru.com/faq/JDBC Going International? http://www.jguru.com/faq/I18N
07-10-2000, 10:15 AM
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
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.