Uploading csv file to Big Query error

[IvanNCC]

Hello all, (apologies if I'm posting in the wrong place)

I am building a node.js script to upload csv files to big query but I am running into a parse error:
1. Error while reading data, error message: Could not parse 'XXXX-X-XX XX:XX:XX' as TIMESTAMP for field date_time_received_utc (position 70) starting at location 1279  with message 'Could not parse 'XXXX-X-XX XX:XX:XX' as a timestamp. Required format is YYYY-MM-DD HH:MM[:SS[.SSSSSS]] or YYYY/MM/DD HH:MM[:SS[.SSSSSS]]'

I believe that I have it in the correct format but I am not sure what the issue is. Has anyone run into this issue?

[aaronscottb]

Welcome to Google Cloud Community!

To properly replicate your use case, can you share the exact timestamp value you are trying to parse?

Thank you!

[JHowardTC]

Make sure you are using a date format that provides a leading zero for single-digit months.