You need to sign in to do that
Don't have an account?
irfan aziz
how to convert a UTC into local time zone??
I am using SOQL and trying to get the data into local time zone. I found one link which does not give a complete answer. The below give the date in local time zone but for time there is only hour_in_day() function. There is no mention of how to retrieve the minutes in local time. Since i am using the SOQL in a python script to extract data from SF i dont see it feasible to declare some complex logic to do the timestamp converstion.
SELECT day_only(convertTimezone(CreatedDate))FROM Opportunity
GROUP BY DAY_only(convertTimezone(CreatedDate))
SELECT day_only(convertTimezone(CreatedDate))FROM Opportunity
GROUP BY DAY_only(convertTimezone(CreatedDate))