Timestamp not working

#1

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?

#2

Si wrote:

Quote:

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/s...-datetime.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Timestamp not working

comp.databases.postgresql.general comp.databases.postgresql.general

Timestamp not working - 11-12-2005 , 09:47 AM

Re: Timestamp not working - 11-12-2005 , 11:52 AM