Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to change Mysql date formate into Qlik sense?

hi,

I have date format in Mysql like this- 

datesubmited.PNG

how to change this format into qliksense date.

Thanks

Tanushree Roy

1 Solution

Accepted Solutions

Re: How to change Mysql date formate into Qlik sense?

Looks like a unix epoch timestamp. Try this:


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


talk is cheap, supply exceeds demand
3 Replies

Re: How to change Mysql date formate into Qlik sense?

Looks like a unix epoch timestamp. Try this:


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


talk is cheap, supply exceeds demand
niceqlik
New Contributor III

Re: How to change Mysql date formate into Qlik sense?

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

Not applicable

Re: How to change Mysql date formate into Qlik sense?

Thanks for your reply.

Its working fine. Thanks a lot.

Tanushree Roy