Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Oct 6, 2000

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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap