How do I set up a field in a table to accept the current date and time? And how do I insert the current time/date into this field?
The best way to do this is to use the internal function CURRENT:
SELECT CURRENT from table_name;
This statement will give you as many rows containing the current date/time as there are rows in table_name. A good trick is to create a dummy table called “dummy” and just insert one blank record into it. Then you can do this:
SELECT CURRENT from dummy;
This statement would give you just one row. If you have a table named “test1” that has a date-time column called when_happened, the following would insert the current time into the table:
INSERT into test1 (when_happened) SELECT CURRENT from dummy;