Time Transform

Data in Time type can be converted to Decimal, Integer or String type. You can also perform the following operations:

Add hours

This operation adds an increment value to the hour.

InputIncrementOutput
23:30:15100:30:15
17:07:12118:07:12

Add milliseconds

This operation adds an increment value to the millisecond.

InputIncrementOutput
23:30:151000023:30:25
17:07:121000017:07:22

Add minutes

This operation adds an increment value to the minute.

InputIncrementOutput
23:30:153000:00:15
17:07:123017:37:12

Add seconds

This operation adds an increment value to the second.

InputIncrementOutput
23:30:154523:31:00
17:07:124517:07:57

Am

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".

InputOutput
16:51:02false
11:29:46true

Hours

This operation shows only the hours from the selected field.

InputOutput
09:28:079
17:56:3917

Max

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.

InputMaximumOutput
07:30:0007:05:0007:30:00
07:01:0007:05:0007:05:00

Milliseconds

This operation shows only the milliseconds from the selected field.

InputOutput
00:30:100
07:31:410

Min

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.

InputMinimumOutput
07:05:0007:30:0007:05:00
07:40:0007:30:0007:30:00

Minutes

This operation shows only the minutes from the selected field.

InputOutput
09:28:0728
17:56:3956

Null to time

This operation displays the Null time as a specified value, while the other values remain the same.

InputValueOutput
 00:00:0000:00:00
07:30:1000:00:0007:30:10

Pm

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".

InputOutput
16:51:02true
11:29:46false

Seconds

This operation shows only the seconds from the selected field.

InputOutput
09:28:077
17:56:3939

Set hour

This operation enables you to set the hour value in the selected field.

InputHourOutput
00:30:102020:30:10
07:31:412020:31:41

Set millisecond

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.

InputValueOutput
00:30:10100:30:10
07:31:41107:31:41

Set minute

This operation enables you to set the minute value in the selected field.

InputValueOutput
00:30:10100:01:10
07:31:41107:01:41

Set second

This operation enables you to set the second value in the selected field.

InputValueOutput
00:30:10100:30:01
07:31:41107:31:01

Subtract hours

This operation subtracts a decrement value from the milliseconds.

InputDecrementOutput
23:30:15518:30:15
17:07:12512:07:12

Subtract milliseconds

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.

InputDecrementOutput
23:30:153023:30:15
17:07:123017:07:12

Subtract minutes

This operation subtracts a decrement value from the minutes.

InputDecrementOutput
23:30:153023:00:15
17:07:123016:37:12

Subtract seconds

This operation subtracts a decrement value from the seconds.

InputDecrementOutput
23:30:151523:30:00
17:07:121517:06:57

To milliseconds

This operation calculates the time value into milliseconds.

InputOutput
07:30:1027010000
00:30:101810000

To seconds

This operation calculates the time value into seconds.

InputOutput
07:30:1027010
00:30:101810

To string format

This operation transforms the time into a specified String format. Use "HH" for hours, "mm" for minutes, and "ss" for seconds. Specify a punctuation to connect the string.

InputString formatOutput
07:30:10HH.mm.ss07.30.10
00:31:41HH.mm.ss00.31.41