Re: problem insert time into column timestamp

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