Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a time bucket in my table and it's starting from '00:00',it is in GMT. I need to convert this time bucket as to Local time (US).
Below is my code and output look like below . When i am using ConvertToLocalTime, its not working converting as expected.
Can anyone advise me on this issue.
The range could starts from 07:00- 07-30.
Time_Bucket:
load *,time(SubField((event_Buckets),'<=',1),'hh:mm') &' - '&
time(SubField((event_Buckets),'<',3),'hh:mm') as Event_Range;
LOAD EventDate,
%StateKey ,
class(frac(ConvertToLocalTime(TimeStamp)),1/48) as event_Buckets,
ConvertToLocalTime(TimeStamp) as TimeStamp ,
ConvertToLocalTime(eventdatetime) as eventdatetime,
from [$(File)](QVD);
Thanks
Krishna
Is this not working?
ConvertToLocalTime(FieldName, 'EST')
If your time is in GMT then try like this , otherwise you need convert the time to GMT or UTC first and then use the formula
ConvertToLocalTime(TimeStamp,'Central Time (US &Canada)')