We have a very large file we are exporting from Skyvia to .zip/.csv. The file has two fields that are text fields but in the format of yyyy-mm-ddThh:mm:ss.000Z. On export however, Skyvia seems to be changing these to date/time fields in the format of MM/DD/YYYY HH:MM:SS. This does not work for us, we need to format to stick to yyyy-mm-ddThh:mm:ss.000Z.
I have exported directly from the source to .csv and the format sticks correctly. However, I can not export all rows from the source this way and need to use Skyvia.