Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vamseekrishna
Contributor II
Contributor II

Hello Qlik Members

Hi Everyone,

I am getting some problem to convert time format. I have time format it's in UTC mode, But i need to change into AEST(Australian Eastern Standard Time )..

Can please help how to convert UTC TO AEST(Australian Eastern Standard Time ) format..

Regards,

Vamsee

6 Replies
neelamsaroha157
Specialist II
Specialist II

May be this can solve your issue -

show data in correct time zone, can I do UTC+10 ?

vamseekrishna
Contributor II
Contributor II
Author

Hi Neelam,

Thank you for your response......

I am tried as same functions but it's not working.. right now I am easy to convert present local time to AEST....

In my data I have large of data like 2017,2016... I am not able to change that format...

Regards,

Vamsee Krishna

neelamsaroha157
Specialist II
Specialist II

Would you mind sharing some sample data?

vamseekrishna
Contributor II
Contributor II
Author

Hi neelam,

I have to 2 date format like

03/05/2018

4/05/2018

    ''

    ''

09/06/2018

this is one format

another one

like this

01/05/2018 4:51:07am

01/05/2018 4:51:13am

02/05/2018 8:02:57am

like

This is my date format in DB

Regards,

Vamsee

jyothish8807
Master II
Master II

Hi Namsee,

Try like this:

Load

Date,

ConvertToLocalTime( Alt(date#(Date,'DD/MM/YYYY'),timestamp(timestamp#(Date,'DD/MM/YYYY hh:mm:sstt'))),'Sydney') as New_Date;

LOAD * INLINE [

    Date

    3/5/2018

    4/5/2018

    9/6/2018

    01/05/2018 4:51:07am

    01/05/2018 4:51:13am

    02/05/2018 8:02:57am

];

Br,

KC

Best Regards,
KC
vamseekrishna
Contributor II
Contributor II
Author

Thank you I will try on this

Regards,

Vamsee