What you're trying to do can be achieved with: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions
with a "D" in a format string. See: http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html Phil. On 14 August 2012 07:30, Deepti Antony <deeptiantony...@gmail.com> wrote: > Hi, > > I have raised an issue in Jira (issue id hive-3378) for a bug in hive. > Please advice us on this issue. > > Thanks, > Deepti.