Re: problem insert time into column timestamp

> frank_lupo a écrit:
> > 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 ?
>
>
> gedis30=# insert into pippo (aa) values(cast ('10:12:12' as time));
>
>

Problem to execute insert command.

gedis30=# insert into pippo (aa) values(cast ('10:12:12' as time));
ERROR: column "aa" is of type 'timestamp with time zone' but expression is of type 'time without time zone'
You will need to rewrite or cast the expression

Bye !!
Frank Lupo (Wolf) !!> frank_lupo a écrit:
> > 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 Ing