do not use the time stamp field use time if you are doing a time instead
of a timestamp
and for the date use a pure date field
HTH
On Wed, 31 Jul 2002, frank_lupo wrote:
> When working with Ingres, it is possible to create a field "date"
> and insert into this a time value e.g. '10:12:12'
> the current date is assigned automatically by Ingres
> e.g. '31/07/2002 10:12:12'
>
> When working with Postgres, I receive an error when trying to insert a
> time value into a timestamp field
> gedis30=# create table pippo (aa timestamp)\g
>
> gedis30=# insert into pippo (aa) values('10:12:12')\g
> ERROR: Bad timestamp external representation '10:12:12'
>
> How can I solve this problem ?
>
> Bye !!
> Frank Lupo (Wolf) !!
>
>
>
> --
> Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
>
> Sponsor:
> Il nostro catalogo completo a casa tua, gratis! Vieni da Peraga, tanti prodotti introvabili per te.
> Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=450&d=31-7
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Darren Ferguson