Re: Expression needed

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 30 Jul 2004 18:10:46 +0200
Message-ID: <410a72be$0$18691$626a14ce@news.free.fr>

"MAB" <bad-email_at_nowhere.com> a écrit dans le message de news:2mv4i5Frkl64U1_at_uni-berlin.de...
> What's the expression to convert strings of the type '28-JUL-04' to
> '2004/07/28' ?
>
> thx
>

to_char(to_date('28-JUL-04','DD-MON-RR'),'YYYY/MM/DD')

--
Regards
Michel Cadot

Received on Fri Jul 30 2004 - 11:10:46 CDT

This message: [ Message body ]
Next message: Chris Leonard: "Re: Invalid attribute in connection string. Nuby needs HELP!"
Previous message: kaeli: "Re: can a field reference the sum of a field in another table?"
In reply to: MAB: "Expression needed"
Next in thread: Mark D Powell: "Re: Expression needed"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US