PostgreSQL: localtimestamp Function
This PostgreSQL tutorial explains how to use the PostgreSQL localtimestamp function with syntax and examples.
Description
The PostgreSQL localtimestamp function returns the current date and time.
Syntax
The syntax for the localtimestamp function in PostgreSQL is:
localtimestamp( [ precision ] )
Parameters or Arguments
- precision
- Optional. The number of digits to round the fractional seconds to.
Note
- The localtimestamp function will return the current date as a 'YYYY-MM-DD HH:MM:SS.US' format.
- Do not put parentheses () after the localtimestamp function when the precision parameter is not specified.
Applies To
The localtimestamp function can be used in the following versions of PostgreSQL:
- PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4
Example
Let's look at some PostgreSQL localtimestamp function examples and explore how to use the localtimestamp function in PostgreSQL.
For example:
postgres=# SELECT localtimestamp; timestamp ---------------------------- 2014-04-24 20:55:09.808294 (1 row) postgres=# SELECT localtimestamp(1); timestamp ----------------------- 2014-04-24 20:55:09.8 (1 row) postgres=# SELECT localtimestamp(2); timestamp ------------------------ 2014-04-24 20:55:09.81 (1 row) postgres=# SELECT localtimestamp(3); timestamp ------------------------- 2014-04-24 20:55:09.808 (1 row)
Advertisements