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
May 23, 2000

Convert Time for Numbers

Question:
Does Informix have a function that converts datetime chars for numbers?

Answer:
Datetime is stored internally as an integer that represents the number of seconds from a certain starting date. The INTERVAL data type stores between two datetime values, while the EXTEND function pulls out various parts of a datetime value.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap