Discussion board where members can get started with Qlik Sense.
I've an database column which data type is timestamp(ex. "2006-03-14 00:00:00") I need to convert this data as 03/14/2006 format in qliksense. Please help.
Do you really want this as a string?
Date(Floor(YourTimeStampField),'MM/DD/YYYY') as Your DateField;
Have a look at this post for the options available in QlikView for date & time formatting.
Get the Dates Right
Date(Floor(Date#(YourTimeStampField, 'YYYY-MM-DD hh:mm:ss')), 'MM/DD/YYYY')
Still getting error. data type column is Timestamp without timezone.