www.HadoopExam.com

HadoopExam Learning Resources

HadoopExam Training, Interview Questions, Certifications, Projects, POC and Hands On exercise access

    40000+ Learners upgraded/switched career    Testimonials

Add minutes to datetime in Hive

Is there a function in Hive one could use to add minutes(in int) to a datetime similar to DATEADD (datepart,number,date)in sql server where datepart can be minutesDATEADD(minute,2,'2014-07-06 01:28:02') returns 2014-07-06 01:28:02
On the other hand, Hive's date_add(string startdate, int days) is in days. Any of such for hours?


 

Visit Home Page : http://hadoopexam.com for more detail . As you are not blacklisted user.

You are here: Home Question & Answer Hadoop Questions Add minutes to datetime in Hive