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: SQL Server
Expertise: Beginner
Feb 14, 2000

DATETIME Type Conversion

Question:
I need some help with the DATETIME data type conversion. I have an Informix database running in a UNIX environment and I need to insert the system hour into an integer type column. I can't find any function to convert the DATETIME value into a number type. I already have a stored procedure that does the insert with other fields. Until now, I was inserting 0 in this field, but now I need to change it.

How can I do this?

Answer:
You're looking for the EXTEND function. If this_date is a date-time data type, the following SQL code will extract the system hour from this_date:

SELECT EXTEND(this_date, hour to hour)
FROM  whatever_table);
DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap