Date Times

  • 4 minute(s) read

Transform and displays date and time values in different ways and formats.

Date Times

This filter and its variants can be applied to metrics and properties of type DATE, INTEGER, LONG or FLOAT.

Depending on the variant options, the underlying numeric value is converted to a date or period and then formatted as desired.

Filter Variants

The set of predefined filter variants that can be used to format values.

millisToTimePeriod2

Converts the time in millis to a formatted duration expressed in hours and minutes.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

7593000 ā†’ 2:06
null or "" ā†’ "-"


millisToTimePeriod

Converts the time in millis to a formatted duration expressed in hours, minutes and seconds.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

7593000 ā†’ 2:06:33
null or "" ā†’ "-"


millisToPeriod

Converts the milliseconds to a formatted duration.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

109980000 ā†’ 2d 6h 33m
null or "" ā†’ "-"


millisToRelativePeriodNoSuffix

Converts the past time in millis to a relative formatted period.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

 1614519061000 ā†’ 6 months
null or "" ā†’ "-"


millisToRelativePeriod

Converts the past time in millis to a relative formatted period.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

 1614519061000 ā†’ 6 months ago
null or "" ā†’ "-"


millisToDateTimeOrShortPeriod

Converts the milliseconds to a localized date and time or to a period in the case of less than 24 hours.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

now - 6h ā†’ 6 hours ago.
1526898865000 ā†’ May 21, 2018 10:34:25.
null or "" ā†’ ""


millisToDateOrShortPeriod

Converts the milliseconds to a localized date or to a period in the case of less than 30 days.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

now - 6d ā†’ 6 days ago.
1526898865000 ā†’ May 21, 2018.
null or "" ā†’ ""


millisToDays

Converts the milliseconds to days.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

86400000 ā†’ 2
null or "" ā†’ 0


millisToTimeUnits

Converts the milliseconds to period displayed in a table with units as headers.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: HTML

273666000 ā†’ Days 3 | Hours 4 | Minutes 1
null or "" ā†’ "-"


millisToTime2

Converts the milliseconds to a formatted time.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

1526898865000 ā†’ 10:34
null or "" ā†’ ""


millisToTime

Converts the milliseconds to a formatted time.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

1526898865000 ā†’ 10:34:25
null or "" ā†’ ""


millisToHours4

Converts the milliseconds to hours with unit, returning "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400000 ā†’ 34 h
null or "" ā†’ 0 h


millisToHours3

Converts the milliseconds to hours with unit, returning "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400000 ā†’ 34 hours
null or "" ā†’ 0 hours


millisToHours3Relative

Computes the difference in millis between the given UTC time and now, and returns the number of elapsed hours with unit, returns "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400000 ā†’ 34 hours
null or "" ā†’ 0 hours


millisToHours

Converts the milliseconds to hours, returns "-" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400000 ā†’ 34
null or "" ā†’ "-"


millisToHoursNotApproximate

Converts the milliseconds to hours, returns "-" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400000 ā†’ 34.5
null or "" ā†’ "-"


millisToHours2

Converts the milliseconds to hours, returns "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

122400000 ā†’ 34
null or "" ā†’ 0


millisToHours2Relative

Computes the difference in millis between the given UTC time and now, and returns the number of elapsed hours, returns "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

122400000 ā†’ 34
null or "" ā†’ 0


millisToHoursNotApproximate3

Converts the milliseconds to hours with unit, returning "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122460000 ā†’ 34.5 hours
null or "" ā†’ 0 hours


millisToHoursNotApproximate2

Converts the milliseconds to hours, returns "0" as default.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: FLOAT

122400000 ā†’ 34.5
null or "" ā†’ 0


hoursToTimeUnits

Converts the time in hours to period displayed in a table with units as headers.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: HTML

76.02 ā†’ Days 3 | Hours 4 | Minutes 1
null or "" ā†’ "-"


millisToMinutes

Converts the milliseconds to minutes.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

122400 ā†’ 2
null or "" ā†’ 0


millisToMinutesNotApproximate

Converts the milliseconds to minutes.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: FLOAT

122400 ā†’ 2.22
null or "" ā†’ 0


millisToDate2

Converts the milliseconds to a localized date.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

1619628734000 ā†’ May 21, 2018
null or "" ā†’ ""


millisToSeconds

Converts the milliseconds to seconds.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

122400 ā†’ 2
null or "" ā†’ 0


millisToSecondsNotApproximate

Converts the milliseconds to seconds.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: FLOAT

122400 ā†’ 2.22
null or "" ā†’ 0


secondsToPeriod

Converts the time in seconds to a formatted duration.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

109980 ā†’ 2d 6h 33m
null or "" ā†’ "-"


secondsToHours3

Converts the time in seconds to hours with unit.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400 ā†’ 34 h
null or "" ā†’ 0 h


secondsToHours2

Converts the time in seconds to hours.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

122400 ā†’ 34 hours
null or "" ā†’ 0 hours


secondsToHours

Converts the time in seconds to hours without decimals.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: INTEGER

122400 ā†’ 34
null or "" ā†’ 0


millisToDate

Converts the milliseconds to a localized date.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

1526898865000 ā†’ 2018-05-21
null or "" ā†’ ""


millisToDateTime

Converts the milliseconds to a localized date and time.


Supported Input Types: INTEGER | NUMBER | DATE


Output Type: STRING

1526898865000 ā†’ 2018-05-21 10:34:25
null or "" ā†’ ""