About RNN

CN · ‎03-24-2021

--show diff values if hour is 02 select '2021-03-14 02:01:03.118', cast('2021-03-14 02:01:03.118' as timestamp) OUTPUT _c0 _c1 1 2021-03-14 02:01:03.118 2021-03-14 03:01:03.118

RNN · ‎10-23-2019

Thanks for your reply, but it didn't work. I tried using other functions but it brings up the date time without milliseconds. But I want the milliseconds as well.

Online	Offline
Last Visited	‎07-09-2020 03:27 PM

Member Since	‎10-23-2019 08:48 AM
Last Visited	‎07-09-2020 03:27 PM
Posts	4

Cloudera Community

Re: Hive - Convert Formatted String to Timestamp

Re: Impala - Convert String to Timestamp