Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Krishna_23
Contributor
Contributor

How to Convert MySQl Date in Qliksense

Hi Team,

I am loading data from mysql to Qlik .

Ex: While loading data,am converting mysql bigint timestamp to Qlik.

from_unixtime(pl.last_modified_time /1000, '%Y-%m-%d %H:%i:%S') AS created_date.

The output  format of  created_date in Qlik is 2020-05-08 16:49:17.

 

I would like to split the above time in Year,Month,Week,date and Time.

Could you please help me how to split the above date format in Qliksense.

Thanks,

Krishna

Labels (2)
0 Replies