Re: Trigger Problems with to_date()

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:mbo5005hn6rmav0ral2qtsm97vb5cvb4or_at_4ax.com...
> 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.

I did! didn't you see this?

   :new.von := to_date(:new.von,'dd/mm/yyyy hh24:mi:ss');   :new.bis := to_date(:new.bis,'dd/mm/yyyy hh24:mi:ss');

> 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
Received on Mon Jan 12 2004 - 14:51:22 CST