devxlogo

Current Time/Date Stamp

Current Time/Date Stamp

Question:
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?

Answer:
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; 

devx-admin

Share the Post: