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));