domo-python-sdk icon indicating copy to clipboard operation
domo-python-sdk copied to clipboard

DOMO-401387: Datetime transformation during upload to domo

Open emilybrehmer-rxa opened this issue 1 year ago • 1 comments

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

emilybrehmer-rxa avatar Jan 19 '24 20:01 emilybrehmer-rxa

I've created a ticket for this issue and it'll get worked on once it's prioritized. Thanks for helping improve the SDK.

samrands avatar Jan 23 '24 20:01 samrands