Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

Looks like a unix epoch timestamp. Try this:


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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Looks like a unix epoch timestamp. Try this:


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


talk is cheap, supply exceeds demand

View solution in original post

niceqlik
Partner
Partner

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
Author

Thanks for your reply.

Its working fine. Thanks a lot.

Tanushree Roy