Hi, I've date stored as [27/Feb/2016:00:24:31 +0530] in string format. I want to cast it to dd/MMM/yyyy format and also want to perform group by from it. More details and tried queries see below question on stackoverflow. http://stackoverflow.com/questions/35668624/hive-cast-string-to-date-in-dd-mmm-yyyy-format-order-by-and-group-by-issue
-- *With Regards:Kapatel Dhruv v*