Discussion board where members can get started with Qlik Sense.
I have date format in Mysql like this-
how to change this format into qliksense date.
Go to Solution.
Looks like a unix epoch timestamp. Try this:
Date(MakeDate(1970) + (date_submitted / 86400)) as date_submitted;
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
Thanks for your reply.
Its working fine. Thanks a lot.