[help] covert to date ??

From: Tina Lee <lee_at_cryptic.rch.unimelb.edu.au>
Date: Tue, 16 Nov 1993 02:40:39 GMT
Message-ID: <9332013.6962_at_mulga.cs.mu.OZ.AU>

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 Received on Tue Nov 16 1993 - 03:40:39 CET

This message: [ Message body ]
Next message: From the terminal emulator of Andrew Dowswell: "Re: [help] covert to date ??"
Previous message: Roger Mathisen: "image databases"
Next in thread: From the terminal emulator of Andrew Dowswell: "Re: [help] covert to date ??"
Reply: From the terminal emulator of Andrew Dowswell: "Re: [help] covert to date ??"
Reply: L. Scott Johnson: "Re: [help] covert to date ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message