[
https://issues.apache.org/jira/browse/TAJO-762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyoungjun Kim updated TAJO-762:
-------------------------------
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.
{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}
was:
There is serveral
NOW() function returns the current time in the TIMESTAMP type.
{noformat}
babokim=# select now();
now
-------------------------------
2014-04-14 20:37:32.820211+09
(1 row)
{noformat}
> 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
>
> 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)
