I'm having one column named - EffectiveDate , which has field type as localdate. As denodo, by default shows date format in 'yyyymmdd', i'm using
command to change its format. Now, the field got changed into text. But, i need this field in localdate type (i.e) my final result should be in 'MM-dd-yyyy' as localdate type.
I used below cast to achive this. But, the column displays only null values. CAST(formatdate('MM-dd-yyyy',EffectiveDate) AS DATE)
Can you please help me with this?
Thanks in advance!