- Last Active
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…
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')…