Time format Issue

1

Hello there.

I have a Mongo database and after every two hours, my data dump on the s3 bucket for dremio. I’m using mongoexport command for exporting data.

The Issue I’m facing is the date format. Dremio is not accepting the simple date format

here is the Screenshot of the error

image
image1203×869 21.5 KB

2

@Fazal From the Dremio docs, do not see this format supported

https://docs.dremio.com/sql-reference/datetime-formats/?parent=sql-reference

3

yes thanks I resolved it with script

4

@Fazal Glad you were able to workaround it