Re: hivecontext and date format

[Mich Talebzadeh]

Try this

SELECT

TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(paymentdate,'dd/MM/'),'-MM-dd'))
AS paymentdate
FROM

HTH

Dr Mich Talebzadeh



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



http://talebzadehmich.wordpress.com



On 1 June 2016 at 12:16, pseudo oduesp  wrote:

> Hi ,
> can i ask you how we can convert string like dd/mm/ to date type in
> hivecontext?
>
> i try with unix_timestemp and with format date but i get null .
> thank you.
>

hivecontext and date format

[pseudo oduesp]

Hi ,
can i ask you how we can convert string like dd/mm/ to date type in
hivecontext?

i try with unix_timestemp and with format date but i get null .
thank you.