All pages
Powered by GitBook
1 of 16

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

TimeSpan

Hours

Name

Hours

Syntax

Hours (TimeSpan timeSpan)

Purpose

To return the Hours component of the specified timeSpan.

Description

Returns Hours component of the specified timeSpan.

Return Type

Int64

Parameter

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Note: The following format will be used for the parameter value: dd:hh:mm:ss

Where,

timeSpan = 20:10:05:10

In the output window, you can see that the provided value’s Hours component has been returned.

Minutes

Name

Minutes

Syntax

Minutes (TimeSpan timeSpan)

Purpose

To return the Minutes component of the specified timeSpan.

Description

Returns Minutes component of the specified timeSpan.

Return Type

Int64

Parameter

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Note: The following format will be used for the parameter value: dd:hh:mm:ss

Where,

timeSpan = 15:10:13:12

In the output window, you can see that the provided value’s Minutes component has been returned.

timeSpan [System.TimeSpan] – TimeSpan for which the Hours component will be returned

timeSpan [System.TimeSpan] – TimeSpan for which the Minutes component will be returned

Milliseconds

Milliseconds (TimeSpan timeSpan)

Name

Milliseconds

Syntax

Milliseconds (TimeSpan timeSpan)

Purpose

To return the Milliseconds component of the specified timeSpan.

Description

Returns Milliseconds component of the specified timeSpan.

Return Type

Int64

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 05:04:03:02.120

In the output window, you can see that the provided value’s Milliseconds component has been returned.

Parameter

timeSpan [System.TimeSpan] – TimeSpan for which the Milliseconds component will be returned

Days

Days (TimeSpan timeSpan)

Name

Days

Syntax

Days (TimeSpan timeSpan)

Purpose

To return the Days component of the specified timeSpan.

Description

Returns Days component of the specified timeSpan.

Return Type

Int64

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Note: The following format will be used for the parameter value: dd:hh:mm:ss

Where,

timeSpan = 12:04:04:09

In the output window, you can see that the provided value’s Days component has been returned.

Parameter

timeSpan [System.TimeSpan] – TimeSpan for which the Days component will be returned

TotalHours

Name

Proper

Applicable To (DataType)

TimeSpan

Purpose

To return a real number representing total number of Hours in the specified timespan.

Description

Returns a real number representing total number of Hours in the specified timespan.

Return Type

Double

Syntax

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 20:10:20:30 (Format: dd:hh:mm:ss)

In the output window, you can see that the timespan value has been converted into a real value, indicating the total number of Hours present in the timespan value.

TimeSpanFromTicks

Ticks

TotalMinutes

timeSpan [System.TimeSpan] – TimeSpan for which the number of Hours will be returned

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

ticks = 9749240000000

In the output window, you can see that the Integer value indicating Ticks has been converted into a TimeSpan value, present in the timespan value.

Name

Proper

Applicable To (DataType)

Int64

Purpose

To convert ticks into a TimeSpan

Description

Returns the converted timeSpan using the ticks.

Return Type

TimeSpan

Syntax

timeSpan [System.TimeSpan] – TimeSpan for which the number of ticks will be returned

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Note: The following format will be used for the parameter value: dd:hh:mm:ss

Where,

timeSpan = 10:03:02:04

In the output window, you can see that the provided value’s number of ticks has been returned.

Name

Ticks

Syntax

Ticks (TimeSpan timeSpan)

Purpose

To return the number of ticks in the specified timeSpan.

Description

Returns number of ticks in the specified timeSpan.

Return Type

Int64

Parameter

timeSpan [System.TimeSpan] – TimeSpan for which the number of ticks will be returned

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 20:03:04:05

In the output window, you can see that the timespan value has been converted into a real value, indicating the number of minutes.

Name

Proper

Applicable To (DataType)

TimeSpan

Purpose

To return a real number representing total number of minutes in the specified timespan.

Description

Returns a real number representing total number of minutes in the specified timespan.

Return Type

Double

Syntax

timeSpan [System.TimeSpan] – TimeSpan for which the number of minutes will be returned

Seconds

Name

Seconds

Syntax

Seconds (TimeSpan timespan)

Purpose

To return the Seconds component of the specified timeSpan.

Description

Returns Seconds component of the specified timeSpan.

Return Type

Int64

Parameter

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 10:03:02:04 (Format: dd:hh:mm:ss)

In the output window, you can see that the provided value’s Seconds component has been returned.

ToTimeSpan

Name

Proper

Applicable To (DataType)

Int64

Purpose

To return the converted timeSpan.

Description

Converts parameters into TimeSpan

Return Type

TimeSpan

Syntax

Example

In this example, we will pass the required parameters to the function transformation object using a Variables object.

Where,

days = 10

hours = 3

minutes = 40

seconds = 50

In the output window, you can see that the integer values have been converted into a TimeSpan value.

TotalMilliseconds

ToTimeSpan (Hours, Min, Sec)

ToTimeSpan (Milli)

timeSpan [System.TimeSpan] – TimeSpan for which the Seconds component will be returned

days [System.Int64] – Number of days in TimeSpan

hours [System.Int64] – Number of hours in TimeSpan

minutes [System.Int64] – Number of minutes in TimeSpan

seconds [System.Int64] – Number of seconds in TimeSpan

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 20:03:04:05 (Format: dd:hh:mm:ss)

In the output window, you can see that the timespan value has been converted into a real value, indicating the total number of milliseconds present in the timespan value.

Name

Proper

Applicable To (DataType)

TimeSpan

Purpose

To return a real number representing total number of milliseconds in the specified timespan.

Description

Returns a real number representing total number of milliseconds in the specified timespan.

Return Type

Double

Syntax

timeSpan [System.TimeSpan] – TimeSpan for which the number of milliseconds will be returned

Example

In this example, we will pass the required parameters to the function transformation object using a Variables object.

Where,

hours = 6

minutes = 50

seconds = 40

In the output window, you can see that the integer values have been converted into a TimeSpan value.

Name

ToTimeSpan

Applicable To (DataType)

Int64

Purpose

To return the converted timespan value.

Description

Converts parameters into a TimeSpan value.

Return Type

TimeSpan

Syntax

hours [System.Int64] – Number of hours in TimeSpan

minutes [System.Int64] – Number of minutes in TimeSpan

seconds [System.Int64] – Number of seconds in TimeSpan

Example

In this example, we will pass the required parameters to the function transformation object using a Variables object.

Where,

days = 10

hours = 3

minutes = 40

seconds = 50

milliseconds = 455

In the output window, you can see that the integer values have been converted into a TimeSpan value.

Name

Proper

Applicable To (DataType)

Int64

Purpose

To return the converted timeSpan.

Description

Converts parameters into TimeSpan

Return Type

TimeSpan

Syntax

days [System.Int64] – Number of days in TimeSpan

hours [System.Int64] – Number of hours in TimeSpan

minutes [System.Int64] – Number of minutes in TimeSpan

seconds [System.Int64] – Number of seconds in TimeSpan

milliseconds [System.Int64] – Number of milliseconds in TimeSpan

TotalSeconds

Name

Proper

Applicable To (DataType)

TimeSpan

Purpose

To return a real number representing total number of seconds in the specified timespan.

Description

Returns a real number representing total number of seconds in the specified timespan.

Return Type

Double

Syntax

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 20:03:04:05

In the output window, you can see that the timespan value has been converted into a real value, indicating the number of seconds.

TotalDays

timeSpan [System.TimeSpan] – TimeSpan for which the number of seconds will be returned

Example

In this example, we will pass the required parameter to the function transformation object using a Variables object.

Where,

timeSpan = 20:10:20:30 (Format: dd:hh:mm:ss)

In the output window, you can see that the timespan value has been converted into a real value, indicating the total number of days present in the timespan value.

Name

Proper

Applicable To (DataType)

TimeSpan

Purpose

To return a real number representing total number of days in the specified timespan.

Description

Returns a real number representing the total number of days in the specified timespan.

Return Type

Double

Syntax

timeSpan [System.TimeSpan] – TimeSpan for which the number of days will be returned.