[PHOENIX-688] Add to_time and to_timestamp built-in functions

• Type: Task
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 3.0-Release
• Fix Version/s: 4.3.0
• old issue number: 557
• Assignee: James R. Taylor
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:48
• Updated: 21/Nov/15 02:17
• Resolved: 10/Feb/15 17:28

Description

We already have a to_date function implemented by ToDateFunction, so adding a ToTimeFunction could be done by just deriving the class from ToDateFunction and changing the getDataType() to be PDataType.TIME instead.

For a general overview on adding a new built-in function, see the phoenix blog [here](http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html)

The to_timestamp function would be similar as well, but in this case we'd want to register a new ToTimestampParseNode (very similar to ToDateParseNode), that uses the DateUtil.getTimestampParser(format) to create the timestamp instance. This class would then be defined in the ToTimestampFunction as the nodeClass attribute (which would cause it to be used to construct a ToTimestampFunction at compile time).