Qlik Community

Ask a Question

New to QlikView

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

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

May be this can solve your issue -

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

Contributor II
Contributor II

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

Specialist II
Specialist II

Would you mind sharing some sample data?

Contributor II
Contributor II

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

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
Contributor II
Contributor II

Thank you I will try on this

Regards,

Vamsee