Now (PQL)
Returns a current date and time as a DateTime value .
- Returned Output: Date-Time
- Library: PQL \ Granular \ Date-Time
- Version: 2023.00.000
- Compatibility: Pyramid Query Language (PQL) data sources
Syntax
Now()
Comments
- This function has no arguments. It computes the result based on the actual current date and time.
- The function is mostly used in conjunction with other date-time logic to generate values, like elapsed time etc.
- For details on how to employ and use this function see the custom column overview.
Different Function types
- This function is similar to the PQL semantic and common functions of the same name. However, it operates on a column directly at the grain.
- As a granular function, it is used in the base SQL query itself.
- Also see the Today function.
Examples
This example returns a column with the current date and time.
Now()
In the example below, the 7th column represents the exact time and date that the report was generated. Note that its the same value for all rows.
