Re: problem insert time into column timestamp - Mailing list pgsql-general

From frbn
Subject Re: problem insert time into column timestamp
Date
Msg-id 3D48EA01.1030707@efbs-seafrigo.fr
Whole thread Raw
In response to problem insert time into column timestamp  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
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));


pgsql-general by date:

Previous
From: g.hintermayer@inode.at (Gerhard Hintermayer)
Date:
Subject: Re: database shutdown with persistent client connections
Next
From: Karel Zak
Date:
Subject: Re: to_char(0,'FM990D99') = "0." instead of "0"