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.

Date and Time

Date and Time or short period

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

Name: millisToDateTimeOrShortPeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

now - 6h -> 6 hours ago.

1526898865000 -> May 21, 2018 10:34:25.

null or empty -> ""

Date or short period

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

Name: millisToDateOrShortPeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

now - 6d -> 6 days ago.

1526898865000 -> May 21, 2018.

null or empty -> ""

HH:mm

Converts the milliseconds to a formatted time.

Name: millisToTime2

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1526898865000 -> 10:34

null or empty -> ""

HH:mm:ss

Converts the milliseconds to a formatted time.

Name: millisToTime

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1526898865000 -> 10:34:25

null or empty -> ""

MMM dd, yyyy

Converts the milliseconds to a localized date.

Name: millisToDate2

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1619628734000 -> May 21, 2018

null or empty -> ""

yyyy-MM-dd

Converts the milliseconds to a localized date.

Name: millisToDate

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1526898865000 -> 2018-05-21

null or empty -> ""

yyyy-MM-dd HH:mm:ss

Converts the milliseconds to a localized date and time.

Name: millisToDateTime

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1526898865000 -> 2018-05-21 10:34:25

null or empty -> ""

Duration

2:06

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

Name: millisToTimePeriod2

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

7593000 -> 2:06

null or empty -> "-"

2:06:33

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

Name: millisToTimePeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

7593000 -> 2:06:33

null or empty -> "-"

2d 6h 33m

Converts the milliseconds to a formatted duration.

Name: millisToPeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

109980000 -> 2d 6h 33m

null or empty -> "-"

Days (###)

Converts the milliseconds to days.

Name: millisToDays

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

86400000 -> 2

null or empty -> 0

Days 3 | Hours 4 | Minutes 1

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

Name: millisToTimeUnits

Input Types: INTEGER, NUMBER, DATE

Output Type: HTML

273666000 -> Days 3 | Hours 4 | Minutes 1

null or empty -> "-"

Hours (### h)

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

Name: millisToHours4

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400000 -> 34 h

null or empty -> 0 h

Hours (### hours)

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

Name: millisToHours3

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400000 -> 34 hours

null or empty -> 0 hours

Hours (### or '-')

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

Name: millisToHours

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400000 -> 34

null or empty -> "-"

Hours (###)

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

Name: millisToHours2

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

122400000 -> 34

null or empty -> 0

Hours (###.# hours)

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

Name: millisToHoursNotApproximate3

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122460000 -> 34.5 hours

null or empty -> 0 hours

Hours (###.#)

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

Name: millisToHoursNotApproximate2

Input Types: INTEGER, NUMBER, DATE

Output Type: FLOAT

122400000 -> 34.5

null or empty -> 0

Hours to 'Days 3 | Hours 4 | Minutes 1'

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

Name: hoursToTimeUnits

Input Types: INTEGER, NUMBER, DATE

Output Type: HTML

76.02 -> Days 3

Hours 4

Minutes 1

null or empty -> "-"

Minutes (###)

Converts the milliseconds to minutes.

Name: millisToMinutes

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

122400 -> 2

null or empty -> 0

Minutes (###.#)

Converts the milliseconds to minutes.

Name: millisToMinutesNotApproximate

Input Types: INTEGER, NUMBER, DATE

Output Type: FLOAT

122400 -> 2.22

null or empty -> 0

Seconds (###)

Converts the milliseconds to seconds.

Name: millisToSeconds

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

122400 -> 2

null or empty -> 0

Seconds (###.#)

Converts the milliseconds to seconds.

Name: millisToSecondsNotApproximate

Input Types: INTEGER, NUMBER, DATE

Output Type: FLOAT

122400 -> 2.22

null or empty -> 0

Seconds to '2d 6h 33m'

Converts the time in seconds to a formatted duration.

Name: secondsToPeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

109980 -> 2d 6h 33m

null or empty -> "-"

Seconds to hours (### h)

Converts the time in seconds to hours with unit.

Name: secondsToHours3

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400 -> 34 h

null or empty -> 0 h

Seconds to hours (### hours)

Converts the time in seconds to hours.

Name: secondsToHours2

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400 -> 34 hours

null or empty -> 0 hours

Seconds to hours (###)

Converts the time in seconds to hours without decimals.

Name: secondsToHours

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

122400 -> 34

null or empty -> 0

Period

6 months

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

Name: millisToRelativePeriodNoSuffix

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1614519061000 -> 6 months

null or empty -> "-"

6 months ago

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

Name: millisToRelativePeriod

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

1614519061000 -> 6 months ago

null or empty -> "-"

Hours (### hours)

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.

Name: millisToHours3Relative

Input Types: INTEGER, NUMBER, DATE

Output Type: STRING

122400000 -> 34 hours

null or empty -> 0 hours

Hours (###)

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

Name: millisToHours2Relative

Input Types: INTEGER, NUMBER, DATE

Output Type: INTEGER

122400000 -> 34

null or empty -> 0