datbaricks to csv export issue

Shambhu Rai 1,406

Hi Expert,
Have changed all the formats to
dd-mm-yyyy but when i export it to the csv file it shows dd/mm/yyyy for some the data

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-09-05T07:54:27.077+00:00

Hello @Shambhu Rai ,

Thanks for the question and using MS Q&A platform.

Can you please share the below details to understand the issue?

How exactly you are exporting the csv file?

Can you please share the date format show before you export the csv file?
Shambhu Rai 1,406 Reputation points

2022-09-05T08:07:44.57+00:00

create table table1(date1 date)
insert into table1
('02/02/1988'),
('02-02/-988'),
('2/2/1988'),
('2-2-1988')

if you can export in excel it showing different format inspite dateformat condition is applied
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-09-06T08:22:32.103+00:00

Hello @Shambhu Rai ,

Could you please help us with the screenshot on how exactly you have created the table1?

When I tried the above command it throws the error message as DateTimeException: Cannot cast to DateType as shown below:
Shambhu Rai 1,406 Reputation points

2022-09-06T09:46:09.723+00:00

Please load it from excel
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-09-08T08:42:54.247+00:00

Hello @Shambhu Rai ,

What do you mean by load it from excel. Please do help us understand the query you are running and how you are exporting to csv file?
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-09-13T05:51:09.167+00:00

Hello @Shambhu Rai ,

Follow up to see if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.