i need help

i need help

I need to calculate the time zone converter from UTC to LOS Angelas time when the time zones change i know i need to use the following but I have no idea how to implement it into my query can you help.

IF( CONVERT_TZ("timestamp_column", '+00:00', '-06:00') between DATE_ADD(NEXT_WEEKDAY(DATE_SUB(TIMESTAMP(CONCAT(YEAR("timestamp_column"),'-03-01 02:00:00')), INTERVAL '1' DAY),1), INTERVAL '7' DAY) and NEXT_WEEKDAY(DATE_SUB(TIMESTAMP(CONCAT(YEAR("timestamp_column"),'-11-01 01:59:00')), INTERVAL '1' DAY),1) , CONVERT_TZ("timestamp_column", '+00:00', '-05:00'), CONVERT_TZ("timestamp_column", '+00:00', '-06:00'))

My query is 

convert_tz("Date and Time" ,'+5:30','+10:00') As "Date",
SUM("Ac-ft") AS "Foothill Ditch Acre-ft",
AVG("data.f100") AS "Foothill Ditch Average",
MAX("data.f100") AS "Foothill Ditch MAX",
MIN("data.f100") AS "Foothill Ditch MIN"
FROM  "ALL-BAA289-Foothill Ditch" 
Group By "Date and Time"
    • Topic Participants

    • Admin

      Zoho SalesIQ Resources

            Zoho TeamInbox Resources

              Zoho DataPrep Resources

                  Zoho CRM Plus Resources

                    Zoho Books Resources

                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources

                            Zoho Sprints Resources

                              Qntrl Resources

                                Zoho Creator Resources

                                  Zoho WorkDrive Resources

                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now

                                                      Zoho Show Resources

                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.