[TAJO-762] Implements current date/time function

• Type: Sub-task
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Assignee: Hyoungjun Kim
• Reporter: Hyoungjun Kim
• Created: 14/Apr/14 11:39
• Updated: 05/Jun/14 00:56
• Resolved: 05/Jun/14 00:46

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)