Skip to content
This is an archived version of the documentation downloaded from LogScale Documentation Archives. Up to date documentation, and documentation for later versions, is available on LogScale Documentation

## Time and Date Query Functions

LogScale's time and date functions manipulate or format time information from events.

Table: Time and Date Query Functions

Function | Default Argument | Availability | Description
--- | --- | --- | ---
`duration([as], duration)` | `duration` | added in 1.113 | Computes the number of milliseconds denoted by a human-readable specification.
`end([as])` | `as` |  | Assign the end of the search time interval to the field provided by parameter `as`.
`findTimestamp([addErrors], [as], [field], [timezone], [timezoneAs])` |  |  | Finds timestamp in given field and parses, trying multiple timestamp formats.
`formatDuration([as], field, [from], [precision])` | `field` |  | Formats a duration into a more readable string.
`now([as])` | `as` |  | Assign the current time to the field provided by parameter `as`.
`parseTimestamp([addErrors], [as], [caseSensitive], field, [format], [timezone], [timezoneAs])` | `format` |  | Parses a string into a timestamp.
`start([as])` | `as` |  | Assign the start of the search time interval to the field provided by parameter `as`.
`time:dayOfMonth([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the day of the month of a timestamp field.
`time:dayOfWeek([as], field, [timezone], [timezoneField])` | `field` |  | Gets day of week from 1 (Mon) to 7 (Sun) of a timestamp.
`time:dayOfWeekName([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the English display name of day of the week of a timestamp field.
`time:dayOfYear([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the day of the year of a timestamp field, from 1 to 365, or 366 in a leap year.
`time:hour([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the hour (24-hour clock) of a timestamp field.
`time:millisecond([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the millisecond of a timestamp field.
`time:minute([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the minute value of a timestamp field.
`time:month([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the month of a timestamp field (from 1 to 12).
`time:monthName([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the English name of month of a timestamp field (for example, January).
`time:second([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the second of a timestamp field.
`time:weekOfYear([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the week number within a year of a timestamp, a value from 1 to 53.
`time:year([as], [field], [timezone], [timezoneField])` | `field` |  | Gets the year of a timestamp field.

#### Enter search term