UTC a JTS Time zone change in python

Question

I want to change UTC time to JTS when I csv the information I get in salesforce.

Is there a way to change the timezone? put an argument of data ['CreatedDate'] = d.astimezone but output the CreatedDate in UTC time. This way I want to change.

UTC            JTS
CreatedDate    CreatedDate
-------------- ---------------
2020/1/1 0:25  2020/1/1 9:25

code

from simple_salesforce import Salesforce
from datetime import datetime
import csv
import os
import json
import account

SALESFORCE_USERNAME = '123'
PASSWORD = '123'
SECURITY_TOKEN = ''

def main():
    # Authentication settings
    sf = Salesforce(username=SALESFORCE_USERNAME,
                    password=PASSWORD,
                    security_token=SECURITY_TOKEN)

    # Lead Column setting to be acquired
    columns = [
        "CreatedDate"
    ]
    sosl = 'SELECT {0[0]} FROM Lead'.format(
        columns)

    # Data acquisition with SOSL
    data = sf.query_all(sosl)

    # Delete CSV file if it exists
    output_csv = 'output.csv'
    if os.path.exists(output_csv):
        os.remove(output_csv)

    # Write to CSV file
    for k, v in data.items():
        if type(v) is list:
            with open(output_csv, 'w', newline="") as f:
                writer = csv.DictWriter(f, fieldnames=columns)
                writer.writeheader()
                for d in v:
                    data = json.loads(json.dumps(d))
                    del data['attributes']
                    data['CreatedDate'], '%Y-%m-%dT%H:%M:%S.%f%z')
                    data['CreatedDate'] = d.astimezone
                    data['CreatedDate'] = d.strftime('%Y-%m-%d %H:%M:%S')
                    writer.writerow(data)
if __name__ == '__main__':
    main()

If anyone knows, please let me know.

question from:https://stackoverflow.com/questions/65842231/utc-a-jts-time-zone-change-in-python

Answer 1

Waitting for answers