ElliotGitter Member

I figured it out: CAST((([YourDateColumn] AT TIME ZONE 'Pacific Standard Time') AT TIME ZONE 'UTC') AS DATETIME) AS 'YourDateColumn'

@ST_-Superman-_ I'll give it a try and see if there is a way. Still working on differences when I change from an ODBC to a SQL connector

@Chris_Wolman That's the plan, thanks for your help

Hi @Chris_Wolman thanks for the tip. Unfortunately no change but worth a try. I'll let you know how it goes when we move servers. Do you know if there is any information on if moving these jobs to the internal Microsoft SQL Server Connector is faster/better? The visibility using the connector method is a lot better for a…

This didn't work for me either (using python), did you ever figure this out? The only problem is, my ds_update is only appending now. Wish there was a clear function like the import noted above that worked.

Hi @mhouston , I just figured it out. I was using the ds_update() function with a variable that had already called the ID which may have been messing with the update. Here is the test case I was running before creating it for my use case. Here is the old way which was giving me the 403 error: testdata = domo.ds_get('myid')…