Bug while adding minutes into timestamp

himanshu

Hi Support,

There is some issue found while adding time into timestamp attribute. Here below is the rule and Test case values to reproduce.

There are two attributes
Attribute Name: Datatype
TDateTime: Timestamp
TMinutes: Number

RULE:
Tminutes WAS CHANGED
TDateTIme = TIME_ADD(TDateTime, Tminutes/60)

Now here are the cases

Current TDateTime : 07/27/15 00:00

Enter value 60, it will add 1 hr to TDateTime attribute which is correct.
Result: 07/27/15 01:00
Enter value 61, which means it has to add 1hr and 1min to TDateTime but it fails here and updating only hr not mins.
Result: 07/27/15 01:00

This is happening on many cases.

Please suggest.

Thanks

aware_support

Try adding a floating point number to a time stamp rather than using TIME_ADD. The value of 1.0 corresponds to one hour, 1.5 is one and half hour and so on

himanshu

It does not work too.

I have change attribute to floating with 2 decimal and entered 1.0 result it add 1 sec to time and 1.5 also same result.

I tried in both way :

TIME_ADD(TDateTime, Tminutes/60)

TDateTime + (Tminutes/60)

aware_support

Does your timestamp format include seconds? If not, it should:
dd/MM/yyyy HH:mm:ss

If you don't include ss in the format the seconds will be cut-off

himanshu

it includes both hh and ss.

Please check the screen shot of the test form.