{"id":10271,"date":"2016-02-25T15:38:51","date_gmt":"2016-02-25T07:38:51","guid":{"rendered":"http:\/\/localhost\/help\/p2-server\/calculations\/time-periods\/durations\/"},"modified":"2024-07-04T16:03:17","modified_gmt":"2024-07-04T08:03:17","slug":"durations","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/time-periods\/durations\/","title":{"rendered":"Time Conversions"},"content":{"rendered":"\n

Format<\/span><\/h2>\n

IFS OI Server provides functions for converting a time (in seconds since 1970 UTC) into a requested component value. The functions all require the same parameters and are used in the same way, but produce a result relevant to the function.\u00a0<\/p>\n

Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n
Format<\/strong><\/td>\nReturns<\/strong><\/td>\n<\/tr>\n
Second(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time<\/em> into the local time zone of the machine executing the calculation, and then returns the seconds component (a value from 0 to 59).<\/td>\n<\/tr>\n
Minute(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time<\/em>\u00a0into the local time zone of the machine executing the calculation, and then returns the minutes component (a value from 0 to 59).<\/td>\n<\/tr>\n
Hour(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time\u00a0<\/em>into the local time zone of the machine executing the calculation, and then returns the hour component (a value from 0 to 23).<\/td>\n<\/tr>\n
Day(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time<\/em>\u00a0argument into the local time zone of the machine executing the calculation, and then returns the day of the month component (a value from 1 to 31).<\/td>\n<\/tr>\n
WeekDay(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time<\/em> into the local time zone of the machine executing the calculation, and then returns the day of the week component (a value from 1 to 7, where 1 is Sunday and 7 is Saturday).<\/td>\n<\/tr>\n
Month(Time [,TimeZone])<\/strong><\/td>\nConverts the specified Time\u00a0<\/em>into the local time zone of the machine executing the calculation, and then returns the month component (a value from 1 to 12 for January to December).<\/td>\n<\/tr>\n
Year(Time [,TimeZone])\u00a0<\/strong><\/td>\nConverts the specified Time\u00a0<\/em>into the local time zone of the machine executing the calculation, and then returns the four-digit year component.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Inputs<\/span><\/h2>\n

Time<\/strong>: The time for\u00a0which to calculate the function.
\nBehaviour: Required
\nDimension: Collection, SingleValue, MultiCollection
\nValid data types: DateTime, Decimal, Integer, String<\/p>\n

Note: You can use the Time<\/a>() function to use a valid DateTime argument.<\/p>\n

TimeZone<\/strong>: The geographical or UTC offset\u00a0time zone (e.g. \"Australia\/Perth\" or \"UTC+08:00\"). If not supplied, it assumes the configured calendar time zone.\u00a0
\nBehaviour:\u00a0Optional
\nDimension: SingleValue
\nValid data types: String<\/p>\n

How to format data types<\/a><\/p>\n

Examples<\/span><\/h2>\n

Expression: Second(Time(), \"Australia\/Perth\")<\/span><\/p>\n

Expression: Minute(Time() - 60, \"UTC+08:00\")<\/span>
\nExpression: Hour(Time(), \"Australia\/Perth\")<\/span>
\nExpression: Day(Time(), \"UTC+08:00\")<\/span>
\nExpression: Weekday(Time(), \"Australia\/Perth\")<\/span>
\nExpression: Month(Time(), \"UTC+08:00\")<\/span>
\nExpression: Year(Time(), \"UTC+08:00\")<\/span><\/p>\n

Release History<\/span><\/h2>\n