Data in Time type can be converted to Decimal, Integer or String type. You can also perform the following operations:
This operation adds an increment value to the hour.
Input | Increment | Output |
---|---|---|
23:30:15 | 1 | 00:30:15 |
17:07:12 | 1 | 18:07:12 |
This operation adds an increment value to the millisecond.
Input | Increment | Output |
---|---|---|
23:30:15 | 10000 | 23:30:25 |
17:07:12 | 10000 | 17:07:22 |
This operation adds an increment value to the minute.
Input | Increment | Output |
---|---|---|
23:30:15 | 30 | 00:00:15 |
17:07:12 | 30 | 17:37:12 |
This operation adds an increment value to the second.
Input | Increment | Output |
---|---|---|
23:30:15 | 45 | 23:31:00 |
17:07:12 | 45 | 17:07:57 |
This operation transforms the time into Boolean type. If the time is before noon, it is changed to "true", otherwise it is changed to "false".
Input | Output |
---|---|
16:51:02 | false |
11:29:46 | true |
This operation changes each value in the selected field to a specified maximum value. If the original value is less than the specified maximum, the result becomes the maximum, otherwise it is unchanged.
Input | Maximum | Output |
---|---|---|
07:30:00 | 07:05:00 | 07:30:00 |
07:01:00 | 07:05:00 | 07:05:00 |
This operation shows only the milliseconds from the selected field.
Input | Output |
---|---|
00:30:10 | 0 |
07:31:41 | 0 |
This operation changes each value in the selected field to a specified minimum value. If the original value is greater than the specified minimum, the result becomes the minimum, otherwise it is unchanged.
Input | Minimum | Output |
---|---|---|
07:05:00 | 07:30:00 | 07:05:00 |
07:40:00 | 07:30:00 | 07:30:00 |
This operation shows only the minutes from the selected field.
Input | Output |
---|---|
09:28:07 | 28 |
17:56:39 | 56 |
This operation displays the Null time as a specified value, while the other values remain the same.
Input | Value | Output |
---|---|---|
00:00:00 | 00:00:00 | |
07:30:10 | 00:00:00 | 07:30:10 |
This operation transforms the time into Boolean type. If the time is between noon and midnight, it is changed to "true", otherwise changed to "false".
Input | Output |
---|---|
16:51:02 | true |
11:29:46 | false |
This operation enables you to set the hour value in the selected field.
Input | Hour | Output |
---|---|---|
00:30:10 | 20 | 20:30:10 |
07:31:41 | 20 | 20:31:41 |
This operation enables you to set the millisecond value in the selected field. If the specified value is not big enough to calculate into seconds, minutes or hours, the result may look the same with the original value. However, the hidden millisecond value can affect comparing and sorting.
Input | Value | Output |
---|---|---|
00:30:10 | 1 | 00:30:10 |
07:31:41 | 1 | 07:31:41 |
This operation enables you to set the minute value in the selected field.
Input | Value | Output |
---|---|---|
00:30:10 | 1 | 00:01:10 |
07:31:41 | 1 | 07:01:41 |
This operation enables you to set the second value in the selected field.
Input | Value | Output |
---|---|---|
00:30:10 | 1 | 00:30:01 |
07:31:41 | 1 | 07:31:01 |
This operation subtracts a decrement value from the milliseconds.
Input | Decrement | Output |
---|---|---|
23:30:15 | 5 | 18:30:15 |
17:07:12 | 5 | 12:07:12 |
This operation subtracts a decrement value from the milliseconds. If the decrement value is not big enough to affect seconds, minutes or hours, the result may look the same with the original value. However, the hidden millisecond value can affect comparing and sorting.
Input | Decrement | Output |
---|---|---|
23:30:15 | 30 | 23:30:15 |
17:07:12 | 30 | 17:07:12 |
This operation subtracts a decrement value from the minutes.
Input | Decrement | Output |
---|---|---|
23:30:15 | 30 | 23:00:15 |
17:07:12 | 30 | 16:37:12 |
This operation subtracts a decrement value from the seconds.
Input | Decrement | Output |
---|---|---|
23:30:15 | 15 | 23:30:00 |
17:07:12 | 15 | 17:06:57 |
This operation calculates the time value into milliseconds.
Input | Output |
---|---|
07:30:10 | 27010000 |
00:30:10 | 1810000 |
This operation calculates the time value into seconds.
Input | Output |
---|---|
07:30:10 | 27010 |
00:30:10 | 1810 |