The point of over-flow is:
2262-04-11 20:00:00
if you go a second earlier it works fine:
2262-04-11 19:23:59

On Wed, Sep 10, 2014 at 5:38 PM, Peyman Mohajerian <mohaj...@gmail.com>
wrote:

> Hi Guys,
>
> I Hive .13 for this conversion:
> select cast('2999-12-31 23:59:59' as timestamp)
> I get:
> 1830-11-23 00:50:51.580896768
> up to around year 2199 it works fine, the work around is to convert the
> string to int and then back to timestamp:
> from_unixtime(unix_timestamp('2999-12-31 23:59:59.000000')
>
> But why is this issue happening in the first place?
>
> Thanks,
>

Reply via email to