Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WwWXxX, udp high ports, d-link extract firmware dsl-2750u, wwwwxxxxx.2G, yxxxcom, WWWXXX, ftp://192.168.100.100, wwwxxx 100, www.xxxcon, wwwxxx

Links

XODOX
Impressum

#1: Timestamp not working

Posted on 2005-11-12 16:47:16 by si

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?

Report this message

#2: Re: Timestamp not working

Posted on 2005-11-12 18:52:43 by Stephen Prinster

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

Report this message