Convert Date format to Month

[#1]

Hi,

I have a format like 17/12/2012 19:35:38 hours, i want only Month in bar chart.

[Gabriel]

Hi Vamsi,

Please try this and just pick the field for your dimension.

OUTPUT:

LOAD

    *

    ,Date(Floor(Timestamp#(DATEFIELD, 'DD-MM-YYYY hh:mm:ss')), 'DD/MM/YYFYY')     AS NewDate

    ,Month(Floor(Timestamp#(DATEFIELD, 'DD-MM-YYYY hh:mm:ss')))                              AS JustMonth

Resident TableName

;

Best Regards,

Gabriel