search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

Support cast from/to DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG #657

Open jtaylor-sfdc opened 10 years ago

jtaylor-sfdc commented 10 years ago

We should support a manual cast between LONG and DATE/TIME/TIMESTAMP, for example:

SELECT epoch_value CAST AS DATE FROM t;
SELECT date CAST AS LONG FROM t;

Requested by Tagged on the mailing list.

jtaylor-sfdc commented 10 years ago

Also support DATE/TIME/TIMESTAMP to/from DECIMAL so nanos can be preserved