Timestamp not working

I have added a field to one of my PostgreSQL tables in the "Timestamp"
datatype, but when I add a row to that table I don't get the date and time
inserted into that column? Do I need to put a default value into the column
too?
si [ Sa, 12 November 2005 16:47 ] [ ID #1136997 ]

Re: Timestamp not working

Si wrote:
> I have added a field to one of my PostgreSQL tables in the "Timestamp"
> datatype, but when I add a row to that table I don't get the date and time
> inserted into that column? Do I need to put a default value into the column
> too?
>
>
Yep. I haven't done this for a while, but if my memory serves me, you
need to use CURRENT_TIME, CURRENT_DATE, or CURRENT_TIMESTAMP as a
default value to populate the column. For more on these functions, see
the docs:

http://www.postgresql.org/docs/8.0/static/functions-datetime .html
Stephen Prinster [ Sa, 12 November 2005 18:52 ] [ ID #1136998 ]
Datenbanken » comp.databases.postgresql.sql » Timestamp not working

Vorheriges Thema: Extracting the year
Nächstes Thema: Generate/Manage a PostgresSQL database using Visio?