Re: TIMESTAMP to DATE conversion for negative unix time

2015-04-01 Thread Alexander Pivovarov
fixed https://issues.apache.org/jira/browse/HIVE-10178 https://reviews.apache.org/r/32715/diff/# On Tue, Mar 31, 2015 at 11:27 PM, Alexander Pivovarov wrote: > correction for the first example > select cast(cast('1966-01-01 00:00:01' as timestamp) as date); > 1966-01-02 > > > On Tue, Mar 31, 20

Re: TIMESTAMP to DATE conversion for negative unix time

2015-03-31 Thread Alexander Pivovarov
correction for the first example select cast(cast('1966-01-01 00:00:01' as timestamp) as date); 1966-01-02 On Tue, Mar 31, 2015 at 11:26 PM, Alexander Pivovarov wrote: > Hi Everyone > > I noticed interesting behaviour for timestamp to date hive type conversion > for negative unix time. > > For

TIMESTAMP to DATE conversion for negative unix time

2015-03-31 Thread Alexander Pivovarov
Hi Everyone I noticed interesting behaviour for timestamp to date hive type conversion for negative unix time. For example: select cast(cast('1966-01-01 00:00:01' as timestamp) as date); 1966-02-02 Should it work this way? Another example select last_day(cast('1966-01-31 00:00:01' as timestamp