Timestamp data need to convert to string

[#1]

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.

[m_woolf]

Do you really want this as a string?

Date(Floor(YourTimeStampField),'MM/DD/YYYY') as Your DateField;

[Colin-Albert]

Have a look at this post for the options available in QlikView for date & time formatting.

Get the Dates Right

[sunny_talwar]

Try this:

Date(Floor(Date#(YourTimeStampField, 'YYYY-MM-DD hh:mm:ss')), 'MM/DD/YYYY')

[#5]

Still getting error. data type column is Timestamp without timezone.