domo-python-sdk
domo-python-sdk copied to clipboard
DOMO-401387: Datetime transformation during upload to domo
I am using pydomo in a jupyter notebook to write a dataframe to a domo instance using the ds_create or ds_update method. The date value stored in my dataframe is formatted as '%m-%d-%Y' and gets converted to a date timestamp during the execution. The issue I'm having is the date is also converted to UTC. I attempted to identify the date values as UTC in the dataframe object, giving it a type datetime64[ns, 'UTC'], but that gets converted to a string value.
I working on a work around to since this throws off all the date values I'm currently using by 1 day, setting January 4th as January 3rd. However a streamlined approach that allowed a time zone identification would be very helpful.
Thank you
I've created a ticket for this issue and it'll get worked on once it's prioritized. Thanks for helping improve the SDK.