Re: TO_CHAR can't convert a date to be inserted.
From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/02
Message-ID: <33934829.52436751_at_www.sigov.si>#1/1
Received on Mon Jun 02 1997 - 00:00:00 CEST
Date: 1997/06/02
Message-ID: <33934829.52436751_at_www.sigov.si>#1/1
Please, can you be more specific?
On Mon, 02 Jun 1997 10:47:37 -0500, Mir <mq_at_wohl.slh.wisc.edu> wrote:
>One of our developers is having problem inserting a record into a
>table that has a TO_CHAR() conversion. However, if he hard-codes the
>date into the insert(), it works.
>
> [SNIP]
>
>Thanks in advance!
>-Mir.
Can you provide any error message the insert is raising? Can you provide us the format mask your developer is using in the TO_CHAR conversion?
Quite common mistake in such conversions is using 'MM' format mask instead of 'MI' for minutes part of the date.
Regards,
Jurij Modic Republic of Slovenia tel: +386 61 178 55 14 Ministry of Finance fax: +386 61 21 45 84 Zupanciceva 3e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000
Received on Mon Jun 02 1997 - 00:00:00 CEST