You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

The function returns the NUMBER of minutes figure of a timestamp represented by the numeric value t in a certain time_zone

Syntax
minute(number t, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
minute(t, LOCAL)

timestamp t has the value March 25th, 2011 23:15:30

The function returns a NUMBER : 900000, it represents 15 minutes in milliseconds.

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

The function returns a NUMBER