René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Can't upload data with \"2019-07-08 08:00:00\" datetime format to Google Bigquery with pandas","articleBody":"#### Environment details\r\n\r\nI'm using pandas with google-cloud-python\r\n\r\n#### Steps to reproduce\r\n\r\n  1. I have a dataframe has datetime format, ex: \"2019-07-08 08:00:00\" and my schema has created column with DATETIME type.\r\n2. I tried covert it to use pq.to_datetime() \r\n3. Then I used load_table_from_dataframe() to insert data.\r\n\r\n#### Code example\r\n\r\n```py\r\nmy_df = get_sessions()  # this return a dataframe has a column name is created which is datetime[ns] type ex :\"2020-01-08 08:00:00\"\r\nmy_df['created'] = pd.to_datetime(my_df['created'], format='%Y-%m-%d %H:%M:%S').astype('datetime64[ns]')\r\nres = bigquery_client.client.load_table_from_dataframe(my_df, table_id)\r\nres.result()\r\n\r\n# exp: my value \"2020-01-08 08:00:00\" is being changed as INVALID or this value \"0013-03-01T03:05:00\" or other wrong value @plamut please help\r\n```\r\nI just updated my problem . Here\r\nThanks!\r\n","author":{"url":"https://github.com/namnguyenbk","@type":"Person","name":"namnguyenbk"},"datePublished":"2020-03-09T16:20:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":36},"url":"https://github.com/56/python-bigquery/issues/56"}