Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Informix Time Query Question

If I have a table name time_hrs that contains the hour value in integer format i.e 7,8,9,10...etc Is there a dynamic query that can convert take the value of the table - the current time and convert the result into minutes?

This is for informix.
0
Dargie
Asked:
Dargie
1 Solution
 
GreymanCommented:
I can almost get you there:


select   datetime(time_hrs.column_name|":00") hour to minute - extend(current, hour to minute)


This will give you an hour to minute datetime variable, but I can't find any commands that return an integer number of minutes from a datetime.  Can you do that in the client instead?  Why do you need to do it?
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now