Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Timestamp data need to convert to string

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.

4 Replies
mwoolf
Honored Contributor II

Re: Timestamp data need to convert to string

Do you really want this as a string?

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

Re: Timestamp data need to convert to string

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

Get the Dates Right

MVP
MVP

Re: Timestamp data need to convert to string

Try this:

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

Not applicable

Re: Timestamp data need to convert to string

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