Julian Date
From: Greg Craigen <gcraigen_at_tmx.mhs.oz.au>
Date: Tue, 16 Nov 93 12:04:08 GMT
Message-ID: <1993Nov16.120408.3926_at_news.mhs.oz.au>
Date: Tue, 16 Nov 93 12:04:08 GMT
Message-ID: <1993Nov16.120408.3926_at_news.mhs.oz.au>
Someone from Melbourne wanted to convert a number field in Julian format to date... I'm sorry I lost the message, but the following should do the job, whoever you are:
to_date(ta_char(julian_date_field, '00009'), 'YYDDD')
Sorry about putting this through the news group
Greg Received on Tue Nov 16 1993 - 13:04:08 CET