Hours value not getting assigned to HH:MM type field

(0) Share

Report

Posted on by Yunus Shaik

330

Hi,

I have created a time field with format hh:mm but the place from where I am retrieving value for this field is returning Hours type value.

When i am assigning hours value in this field, it is not getting assigned.

Maybe this is because its format is HH:MM and I am assigning hours.

How to convert this Hours value to HH:MM format?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Please show us what you're doing.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Yunus,

You can try this:

myTable.Time = DateTimeUtil::addHours(time, hours);

or use functions like str2time()

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If you are getting time in hours , you can take value before decimal as hour and can calculate minutes as per the other part.

eg: 13.60 hr --> 13:36 (13 hour 36 minutes)

basically, 60 * (60/100)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Time fields store the time in milliseconds I believe. So if you want to store given hours you have to convert them to milliseconds manually by multiplying or as others mentioned with a function.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Time data type represents time is seconds (not miliseconds) since midnight. Nevertheless I'm still not sure what's Yunus's problem, so might be off-topic.

Was this reply helpful? Yes No
Yunus Shaik 330 on at

Like (0)

Report

I have created a table field which stores time in HH:MM format.

I am invoking a standard method for storing value in this custom field.

But this standard method's return type is Hours so the return value is not getting assigned in my table's custom field.

Do I need to change the field's datatype to string and append the return value with :00 for this?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Let me try to fill some gaps in your description and please confirm that I did it right:

The type of your field is timeOfDay.

The type of Hours is int, representing a number of hours.

You're trying to assign the int value to the timeOfDay field, which obviously can't work without conversion.

If it's the case, you have to multiply the number of hours with number of seconds in an hour (use #TimeConstants macro). Also, if the number of hours may be higher than 23, you should normalize it before the conversion (it can be easily done with the mod operator).

Was this reply helpful? Yes No
Yunus Shaik 330 on at

Like (0)

Report

Yes Martin, you are right.

Thanks.

Was this reply helpful? Yes No