[
https://issues.apache.org/jira/browse/TAJO-762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyoungjun Kim updated TAJO-762:
-------------------------------
Priority: Trivial (was: Major)
> Implements current date/time function
> -------------------------------------
>
> Key: TAJO-762
> URL: https://issues.apache.org/jira/browse/TAJO-762
> Project: Tajo
> Issue Type: Sub-task
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Priority: Trivial
> Attachments: TAJO-762.patch
>
>
> 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.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
