Auto Insert date/time 
Author Message
 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://www.***.com/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Fri, 24 Sep 2004 14:08:10 GMT
 Auto Insert date/time

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 its name says: The
actual timestamp at the time of executing the query.

mfg Frank.


Quote:
> 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


--
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")

---------------------------(end of broadcast)---------------------------



Sat, 25 Sep 2004 02:57:24 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Auto insert of Date/Time, to be exported to SQL server

2. INSERT TRIGGER to convert UNIX date time to DATE

3. Auto Date/Time

4. Auto Insert Date

5. Auto Insert Date

6. MySQL ODBC - Coverting Access date/time type to MySQL date/time type

7. ADO with Access Date/Time field not storing the time, just the date

8. Calculate difference between start date and time and end date and time

9. java Date/Time-->MSAccess Date/Time?

10. Getting Date/Time from LAN Machine and Setting Date/Time on Client

11. Unix time/date => Pick time/date

12. how to change dates or times in a oracle date time field


 
Powered by phpBB® Forum Software