Re: External Representation

On Sabato, ott 4, 2003, at 16:35 Europe/Rome, Philip Mötteli wrote:

> Hi
>
>
> When I try to save a date to my Postgres db, I always have the same 
> error:
>
> ERROR:  Bad abstime external representation '10-03-2003 14:15:16 
> Europe/Zurich'
>
>
> In EOModeler I have chosen 'abstime' as the external type and Date 
> (NSCalendarDate) with the local timezone (Europe/Zurich) as the 
> internal data type.
> I have initialized the db with 'initdb --locale=de_CH' and set 
> "datestyle = 'sql, us'".
>
> Can anybody give me a hint, what else I could try?

With postgreSQL, I usually use timestamptz as external type.
Also, I've found this on docs for version 7.2:

> The types abstime and reltime are lower precision types which are used 
> internally. You are discouraged from using any of these types in new 
> applications and are encouraged to move any old ones over when 
> appropriate. Any or all of these internal types might disappear in a 
> future release.

Which version are you running?

HTH

--
Giorgio Valoti
-------------