Hive Tutorial - 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions

This video tutorial talks about the unix timestamp functions in Hive.
The timestamp functions like, from_utc_timestamp(), to_utc_timestamp() are explained in details.
UNIX EPOCH explanation:
// Timezone specific
SELECT UNIX_TIMESTAMP();
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP());
SELECT from_utc_timestamp('2020-03-28 11:56:55', 'IST');
SELECT to_utc_timestamp ('','IST');
// General Date functions
SELECT TO_DATE('2020-03-28 11:56:55');
SELECT WEEKOFYEAR('2020-03-28 11:56:55');
SELECT DATEDIFF('2020-03-28','2020-03-28');
SELECT DATE_ADD('2020-03-28', 5);
SELECT DATE_SUB('2020-03-28', 5);
#Hive Functions - Extracting Information from Dates

[@siva_garlapati]

Fantastic EXPLANATION
I was a beginner and I had learnt this concept at first sitting

[@SwatechTalks]

Glad it helped!

[@SwatechTalks]

pls subscribe and stay tunned for more of such tutorials

[@kaladharnaidusompalyam851]

No doubts, you explained deeply.we can practise along with you like that you made your video. Thankx dude ,very useful one

[@SwatechTalks]

Thanks for your words.. means a lot!! Don't forget to subscribe to channel and keep learning!

[@nishantchavan2980]

Please keep adding such good videos

[@SwatechTalks]

sure thanks! pls watch the space for more

[@anushareddy5945]

Found your vedios helpful sir.
Can you explain how to convert 12-july-2021 to 12-7-2021

[@deepakkumar-yl6nc]

Thanks

[@Priyanka-xh9gs]

If we had a column in hive table filled with 500 rows of IST times, is there a command to change all those times to epoch time in one shot

[@SwatechTalks]

Yes.. there is a tutorial for this on the channel. Pls refer the date and time tutorial

[@vinu1989sharma]

Hi I have a time like '1606297805907000' so how can I convert this in actual value like '2020-11-25 09:50:05.907000' and this is IST timestamp.