How to change Mysql date formate into Qlik sense?

[#1]

hi,

I have date format in Mysql like this- 

how to change this format into qliksense date.

Thanks

Tanushree Roy

[Gysbert_Wassenaar · Accepted solution]

Looks like a unix epoch timestamp. Try this:

Date(MakeDate(1970) + (date_submitted / 86400)) as date_submitted;

[niceqlik]

Hi Tanushree,

The easiest way to get actual date format from unix time is to do this in your sql query like below:

select FROM_UNIXTIME(yourdatefield) as date from yourtable

[#4]

Thanks for your reply.

Its working fine. Thanks a lot.

Tanushree Roy