Re: Julian dates in Query/400

dkazinski

Member
Re: Julian dates in Query/400

--0__=9nRUwigDN1EbqCIuMkrs0McIxBKd5z26NCwi5w2pONChetSdZ5xu8sCO
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline


Hi,
the formula is date(substr((digits(XXXXXX + 1900000)),2,7))

XXXXXX =
date field
Hope this helps. Debbie Kazinski
Pentair Water Treatment




"de Orla, Chris" <[email protected]> on 01/03/2001 11:43:55 AM

Please respond to [email protected]

To: [email protected], [email protected]
cc: (bcc: Debbie Kazinski/FLECKHQ/PENTAIR/US)

Subject: Julian dates in Query/400



I know I've seen this before in here, but can't seem to find it. Is there a
way to convert a julian date to a gregorian date in an AS400 Query and what
is the formula to do so ?

Thanks,

Cd


--0__=9nRUwigDN1EbqCIuMkrs0McIxBKd5z26NCwi5w2pONChetSdZ5xu8sCO
Content-type: text/html;
name="att1.htm"
Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+
DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o
dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U
PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjY1MC4xMiI+DQo8VElUTEU+SnVsaWFu
IGRhdGVzIGluIFF1ZXJ5LzQwMDwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCg0KPFA+PEZPTlQg
U0laRT0yPkkga25vdyBJJ3ZlIHNlZW4gdGhpcyBiZWZvcmUgaW4gaGVyZSwgYnV0IGNhbid0IHNl
ZW0gdG8gZmluZCBpdC4gSXMgdGhlcmUgYSB3YXkgdG8gY29udmVydCBhIGp1bGlhbiBkYXRlIHRv
IGEgZ3JlZ29yaWFuIGRhdGUgaW4gYW4gQVM0MDAgUXVlcnkgYW5kIHdoYXQgaXMgdGhlIGZvcm11
bGEgdG8gZG8gc28gPzwvRk9OVD48L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj5UaGFua3MsPC9GT05U
Pg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+Q2Q8L0ZPTlQ+DQo8L1A+DQoNCjwvQk9EWT4NCjwv
SFRNTD4=

--0__=9nRUwigDN1EbqCIuMkrs0McIxBKd5z26NCwi5w2pONChetSdZ5xu8sCO--
 
Back
Top