What you're trying to do can be achieved with:
with a "D" in a format string. See:
On 14 August 2012 07:30, Deepti Antony <[EMAIL PROTECTED]> wrote:
> I have raised an issue in Jira (issue id hive-3378) for a bug in hive.
> Please advice us on this issue.