Re: Trigger Problems with to_date()

On Mon, 12 Jan 2004 17:38:30 +0100, "clanos" <clandos_at_yahoo.com> wrote:

>I still get the same error message
>"[1]: (Error): ORA-01830: date format picture ends before converting entire
>input string"
>
>What am I doing wrong?

Not reading the documentation of the to_date function. The default format is dd-mon-yy, if you are using a different format you need to specify that in the to_date function.
A far more better solution would be to set the nls_date_format environment variable/registry variable on the client, the 'solution' you are developing now is cumbersome, and requires too much maintenance.

--
Sybrand Bakker, Senior Oracle DBA