Thread: Auto Insert date/time
What 'serial' does for auto incrementation of intgers, are there something similar in PSQL where the db can autoinsert the correct date/time data each time you add a new row , without have to specify the code e.g. Date() class in a java/C++ file? If well, how do I manage to make this work? Is there maybe an PSQL function which can do it? AN example will be nice :) Big Thanks Smith __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/
On Sun, Apr 07, 2002 at 11:06:54PM -0700, impala wrote: > What 'serial' does for auto incrementation of intgers, > are there something similar in PSQL where the db can > autoinsert the correct date/time data each time you > add a new row , without have to specify the code e.g. > Date() class in a java/C++ file? If well, how do I > manage to make this work? Is there maybe an PSQL > function which can do it? AN example will be nice :) At a guess, you would set the default value of the column to now(). I beleive this is in the docs somewhere... HTH, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Ignorance continues to thrive when intelligent people choose to do > nothing. Speaking out against censorship and ignorance is the imperative > of all intelligent people.
Hi, something like "INSERT INTO mytable (row1,row2,rowdate) VALUES ('value1','value2',CURRENT_TIMESTAMP)" does that work for me. The function CURRENT_TIMESTAMP gives exactly, what it´s name says: The actual timestamp at the time of executing the query. mfg Frank. On 08-Apr-02 impala sat down, thought for a long time and then wrote: > What 'serial' does for auto incrementation of intgers, > are there something similar in PSQL where the db can > autoinsert the correct date/time data each time you > add a new row , without have to specify the code e.g. > Date() class in a java/C++ file? If well, how do I > manage to make this work? Is there maybe an PSQL > function which can do it? AN example will be nice :) > > Big Thanks > Smith > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) -- Frank Finner Thus we are all responsible for one another, through all the myriad dimensions of time and space that make up the multiverse . . . (M. Moorcock, "The Revenge Of The Rose")