Date format changing while exporting from sql to excel

[Hemant_Deshmukh]

hi,
I am exporting data from sql to excel. but problem is that while exporting time column getting convert into 12 hour format . i have this format in sql- “02-11-2025 13.41.03” but in excel its showing -“02-11-2025 01.41.00 PM”.

how to solve this problem.

[V_Roboto_V]

Are you using Write Range Workbook or Excel Activities? and are you saving the datable into excel or individual values to a cell ?

[ashokkarale]

@Hemant_Deshmukh,

The DateTime format shown in the excel gets inherited from system DateTime format.

You will have to format the column to desired format using Format cells activity

Select Format data as type property to custom and provide this format

MM-dd-yyyy hh.mm.ss AM/PM

[Hemant_Deshmukh]

yes i am using write range to paste data to excel.

[Hemant_Deshmukh]

expected format is this 02-11-2025 13.41.03

[ashokkarale]

@Hemant_Deshmukh

Use this format

MM-dd-yyyy hh.mm.ss

[Sanjay_Bhat]

Hi @Hemant_Deshmukh

If formating does not work you can do post changes with a Linq

dt_Result=dt_InputData.AsEnumerable().Select(Function(row) dt_InputData.Clone.LoadDataRow( New Object(){
row("Column1").ToString,
row("Column2").ToString,
DateTime.ParseExact(row("DateColumn").ToString(),"dd-MM-yyyy hh.mm.ss tt", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy HH.mm.ss") },
False)).CopyToDataTable()

Sample input and output:

Hope this helps!