Example

In this example, we will pass a date time offset value, and an integer value (indicating days to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-02-2023

days = 8

In the output window, you can see that the provided integer value, indicating the number of days, has been added to the given date time offset value.

Example

In this example, we will pass a date time value, and an integer value (indicating minutes to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022 01:30:00

minutes = 20

In the output window, you can see that the provided integer value, indicating minutes, has been added to the given date time value.

Example

In this example, we will pass a date time value, and an integer value (indicating seconds to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022 12:00:20

seconds = 30

In the output window, you can see that the provided integer value, indicating seconds, has been added to the given date time value.

Example

In this example, we will pass a date time offset value, and an integer value (indicating minutes to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01/02/2023 03:30:35 AM

minutes = 8

In the output window, you can see that the provided integer value, indicating minutes, has been added to the given date time offset value.

Example

In this example, we will pass a date time value, and an integer value (indicating hours to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022 01:00:00

hours = 5

In the output window, you can see that the provided integer value, indicating the number of hours, has been added to the given date time value.

Example

In this example, we will pass a date time value, and an integer value (indicating years to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022

years = 10

In the output window, you can see that the provided integer value, indicating years, has been added to the given date time value.

Example

In this example, we will pass a date time offset value, and an integer value (indicating months to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-02-2023

months = 8

In the output window, you can see that the provided integer value, indicating months, has been added to the given date time offset value.

Note

Example

In this example, we will pass a date time offset value, and an integer value (indicating years to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01/02/2023

years = 5

In the output window, you can see that the provided integer value, indicating years, has been added to the given date time offset value.

Example

In this example, we will pass a date time value, and an integer value (indicating days to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022

days = 5

In the output window, you can see that the provided integer value, indicating the number of days, has been added to the given date time value.

Example

In this example, we will pass date time values, and an integer value (indicating a specific interval) to the function transformation object using a Variables object.

Where,

start = 01-01-2022

end = 05-10-2024

interval (4 = day) = 4

In the output window, you can see that the provided interval value, indicating days, has been used to compute the age/difference of days between the two specified date time values.

Example

In this example, we will pass date time offset values, and an integer value (indicating a specific interval) to the function transformation object using a Variables object.

Where,

start = 01/03/2022

end = 06/06/2022

interval (3=week) = 3

In the output window, you can see that the provided interval value, indicating weeks, has been used to compute the age between the two specified date time offset values.

Example

In this example, we will pass a date time value, and an integer value (indicating months to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022

months = 5

In the output window, you can see that the provided integer value, indicating months, has been added to the given date time value.

Example

In this example, we will pass a date time offset value, and an integer value (indicating seconds to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01/02/2023 01:30:25

seconds = 5

In the output window, you can see that the provided integer value, indicating seconds, has been added to the given date time offset value.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/03/2024

rightDate = 06/06/2022

In the output window, you can see that the provided date time offset, and date time values have been subtracted, and the output has been displayed in the form of days.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/03/2024

rightDate = 06/06/2022

In the output window, you can see that the difference between the provided date time offset, and date time values has been displayed in the form of months.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/03/2024 01:50:30 AM

rightDate = 06/06/2022 01:50:35 PM

In the output window, you can see that the provided datetime values have been subtracted, and the output has been displayed in the form of hours.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/03/2024

rightDate = 06/06/2022

In the output window, you can see that the difference between the provided date time offset, and date time values has been displayed in the form of years.

Example

In this example, we will pass a date time string (timestring) value to the function transformation object using a Variables object.

Where,

timestring = 12:50:10

In the output window, you can see that the provided timestring value has been used to compute the total number of seconds since the beginning of the day.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/01/2023

rightDate = 01/02/2022

In the output window, you can see that the difference between the provided datetime values has been displayed in the form of years.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/01/2023

rightDate = 01/02/2022

In the output window, you can see that the provided datetime values have been subtracted, and the output has been displayed in the form of hours.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/01/2023

rightDate = 01/02/2022

In the output window, you can see that the provided datetime values have been subtracted, and the output has been displayed in the form of days.

Example

In this example, we will drag-and-drop the Now function transformation object to the dataflow designer window.

Right-click on the function transformation object and select Preview Output. You can see that Astera has returned the current system date time value.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

This function accepts the following date formats mentioned in the screenshot

Where,

dateTime = 07/06/2013

In the output window, you can see that the month part of the provided date time value has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 7/13/2022 4:12:19 PM

In the output window, you can see that the provided datetime value has been returned with the time part reset to 12:00:00 AM.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

This function accepts the following date formats:

Where,

dateTime = 11/12/2013

In the output window, you can see that the month part of the provided date time offset value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 02/03/2020

In the output window, you can see that the calendar quarter of the provided date time offset value has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 11/12/2013 2:20:15 PM

In the output window, you can see that the second part of the provided date time value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 2:20:39 PM

In the output window, you can see that the second part of the provided date time offset value has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 08/15/2020

In the output window, you can see that the calendar quarter of the provided date time value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 7/14/2022 1:30:20 PM

In the output window, you can see that the provided value has been converted into an integer value, representing time.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 11:30:12 PM

In the output window, you can see that the provided value has been converted into an integer value, representing time.

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/01/2023

rightDate = 01/02/2022

In the output window, you can see that the difference between the provided datetime values has been displayed in the form of months.

Example

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

Where,

dateStr = 15/JUN/17

format = dd/MMM/yy

In the output window, you can see that the provided dateStr value, of the specified format value, has been converted into a date time value.

Example

In this example, we will pass an integer value, representing seconds, to the function transformation object using a Variables object.

Where,

secondsToday = 123456789

In the output window, you can see that the provided value has been converted into a string value, representing the computed time.

Example

In this example, we will pass valid integer values to the function transformation object using a Variables object.

Where,

year = 2020

month = 01

day = 30

hour = 4

minute = 30

second = 10

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

Example

In this example, we will pass a valid UTC date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 09/10/2020 10:10:25 AM

In the output window, you can see that the provided UTC date time value has been converted into a local date time value.

Example

In this example, we will pass a date-time offset value to the function transformation object using a Variables object.

Where,

dateTime = 01/03/2024 10:23:40 AM

In the output window, you can see that the provided date-time value has been returned with the time-offset part reset to 12:00:00 AM.

Example

In this example, we will pass a valid date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 09/08/2050 10:24:30 AM

In the output window, you can see that the provided date time value has been converted into a Julian date.

Example

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

Where,

dateStr = 15/13/MAR

format = dd/yy/MMM

In the output window, you can see that the provided dateStr value, of the specified format value, has been converted into a date time offset value.

Example

In this example, we will pass valid integer values to the function transformation object using a Variables object.

Where,

year = 2017

month = 12

day = 25

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

Example

In this example, we will drag-and-drop the Today function transformation object to the dataflow designer window.

Right-click on the function transformation object and select Preview Output. You can see that Astera has returned the current system date.

Example

In this example, we will pass a Unix time stamp value to the function transformation object using a Variables object.

Where,

unixTimeStamp ­= 1431053627.234523

In the output window, you can see that the provided Unix time stamp value has been converted into a date time value.

Example

In this example, we will pass valid integer values to the function transformation object using a Variables object.

Where,

year = 1990

month = 01

day = 20

hour = 13

minute = 30

second = 05

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

Example

In this example, we will pass valid integer values to the function transformation object using a Variables object.

Where,

year = 2020

month = 01

day = 30

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

Example

In this example, we will drag-and-drop the UtcNow function transformation object to the dataflow designer window.

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the current UTC system date and time value.

Example

In this example, we will pass a valid date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 03/11/2009 10:20:40 AM

In the output window, you can see that the provided date time value has been converted into a Unix Epoch value.

Example

In this example, we will pass a valid date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 08/06/2018 10:20:40 AM

In the output window, you can see that the provided date time value has been converted into a UTC date time value.

Example

In this example, we will pass a valid date time offset value to the function transformation object using a Variables object.

Where,

dateTime ­= 03/11/2009 10:20:40 AM

In the output window, you can see that the provided date time offset value has been converted into a Ticks value.

Example

In this example, we will pass a valid date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 04/10/2020 10:10:25 AM

In the output window, you can see that the provided value has been converted into a Julian day number.

Example

In this example, we will pass a valid date time value to the function transformation object using a Variables object.

Where,

dateTime ­= 09/10/2020 10:10:25 AM

In the output window, you can see that the provided date time value has been converted into a Ticks value.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 02/01/2020

In the output window, you can see that the year part of the provided date time value has been returned.

Example

In this example, we will pass a date time value and an integer value to the function transformation object using a Variables object.

Where,

dateTime = 05/06/2022

length = 7

In the output window, you can see that the provided date time value has been converted into Julian format of the specified length.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 30/JUN/2022

In the output window, you can see that the day part of the provided date time offset value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 12/11/2001

In the output window, you can see that the year part of the provided date time offset value has been returned.

Example

In this example, we will drag-and-drop the DateTimeOffsetUtcNow function transformation object to the dataflow designer window.

Current system time:

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the current UTC system date and time.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 10/30/2015

In the output window, you can see that the day part of the provided date time value has been returned.

Example

In this example, we will drag-and-drop the DateTimeOffsetNow function transformation object to the dataflow designer window.

Current system time:

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the current system date time with offset value.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 08/06/2018

In the output window, you can see that the week part of the provided date time value has been returned.

Example

In this example, we will pass a date time offset value and an integer value to the function transformation object using a Variables object.

Where,

dateTime = 05/06/2014 12:00:00 AM +05:00

length = 5

In the output window, you can see that the provided date time offset value has been converted into Julian format of the specified length.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 10/20/2022

In the output window, you can see that the day of the week, Thursday, has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 07/16/2022

In the output window you can see that the day of the week, Saturday, has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 02/01/2020

In the output window, you can see that the week part of the provided date time offset value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 07/16/2022

In the output window, you can see that the day of the week, Saturday, has been returned in its integer form, 6.

Example

In this example, we will pass a real value, representing a Julian date, to the function transformation object using a Variables object.

Where,

julianDate = 2253045.340

In the output window you can see that the specified Julian date has been converted into a date time value.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 07/14/2022

In the output window, you can see that the day of the week, Thursday, has been returned in its integer form, 4.

Example

In this example, we will pass an integer value, representing ticks, to the function transformation object using a Variables object.

Where,

ticks = 123456789011121314

In the output window you can see that the specified ticks value has been converted into a UTC date time value.

Example

In this example, we will pass an integer value, representing a Julian day, to the function transformation object using a Variables object.

Where,

julianDayNumber = 2253045

In the output window you can see that the specified Julian day has been converted into a date time value.

Example

In this example, we will pass an integer value, representing Unix epoch, to the function transformation object using a Variables object.

Where,

unixEpoc = 1660450105

In the output window you can see that the specified Unix epoch value has been converted into a date time value.

Example

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

Where,

year = 2030

month = 7

In the output window you can see that the number of days in the specified month of the specified year has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 09/04/2022 03:40:35 AM

In the output window, you can see that the hour part of the provided date time value has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 10/20/2022

In the output window you can see that the day of the year has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 10/30/2020

In the output window you can see that the day of the year has been returned for the specified date time offset value.

Example

In this example, we will pass a Julian date string to the function transformation object using a Variables object.

Where,

julianDate = 2356765

In the output window, you can see that the provided value has been converted into a date time value.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 01/01/2022 3:40:35 PM

In the output window, you can see that the provided value has been converted into an integer value, representing the specified date.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 06:40:35 AM

In the output window, you can see that the minute part of the provided date time value has been returned.

Example

In this example, we will pass a date time offset value to the function transformation object using a Variables object.

Where,

dateTime = 06:40:35 AM

In the output window, you can see that the hour part of the provided date time offset value has been returned.

Example

In this example, we will pass a date time value to the function transformation object using a Variables object.

Where,

dateTime = 05/05/2022 01:30:00 PM +05:00

In the output window, you can see that the provided value has been converted into an integer value, representing the specified date.

Example

In this example, we will pass an integer value, representing ticks, to the function transformation object using a Variables object.

Where,

ticks = 123456789101111213

In the output window you can see that the specified ticks value has been converted into a date time value.