Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this can solve your issue -
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
Would you mind sharing some sample data?
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
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
Thank you I will try on this
Regards,
Vamsee