Re: [help] covert to date ??
From: L. Scott Johnson <lscott_at_crl.com>
Date: 17 Nov 1993 04:13:11 -0800
Message-ID: <2cd4gn$hjg_at_crl.crl.com>
Date: 17 Nov 1993 04:13:11 -0800
Message-ID: <2cd4gn$hjg_at_crl.crl.com>
In article <9332013.6962_at_mulga.cs.mu.OZ.AU> lee_at_cryptic.rch.unimelb.edu.au (Tina Lee) writes:
>hi,
>I have a number field, stores julian date in format 'YYDDD', I want to convert
>it to date, I have tried "to_date(to_chart(julfield, '9999'), 'YYDDD')", but it
>does not work because, some of the julfield has 0 !!, how do I get around that
>problem please ??
>
>TL
If the zero means 'no entry' (or null), try decode(julfield,0,null,to_date(to_char(julfield,'09999','YYDDD')
Scott Received on Wed Nov 17 1993 - 13:13:11 CET