Connecting Tech Pros Worldwide Forums | Help | Site Map

Timestamp not working

Si
Guest
 
Posts: n/a
#1: Nov 23 '05
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?



Stephen Prinster
Guest
 
Posts: n/a
#2: Nov 23 '05

re: Timestamp not working


Si wrote:[color=blue]
> 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?
>
>[/color]
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
Closed Thread