Details
-
Type:
Sub-task
-
Status: Resolved
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 0.9.0
-
Component/s: None
-
Labels:None
Description
There is several functions or keywords to get current date/time value.
- current_timestamp: Returns the current timestamp in the TIMESTAMP type.
- current_date: Returns the current time in the DATE type.
- current_time: Returns the current time in the TIME type.
- now(): Returns the current timestamp in the TIMESTAMP type.
babokim=# select current_timestamp, current_date, current_time, now(); now | date | timetz | now -------------------------------+------------+--------------------+------------------------------- 2014-05-13 21:22:39.566864+09 | 2014-05-13 | 21:22:39.566864+09 | 2014-05-13 21:22:39.566864+09 (1 row)