convert DataTable entire column to YYYY/MM/DD format without for-loop from YYYY-MM-DDT00:00:00

Question

User-1971168174 posted

Hi ,

I have one Datatable which has multiple columns with dates in the format (YYYY-MM-DDT00:00:00 ), need to convert this to YYYY/MM/DD.

Thanks in Advance!

Answer 1

User-719153870 posted

Hi neerajkumarmodi,

with dates in the format (YYYY-MM-DDT00:00:00 ), need to convert this to YYYY/MM/DD.

Please check DateTime.ToString Method and you will find it's actually very easy to use .tostring() method to convert datetime format to whichever you want.

Check below code:

dt.ToString("yyyy/MM/dd")

This will output your dt as like 2020/01/21(YYYY/MM/DD).

Best Regard,

Yang Shen

Answer 2

User-1780421697 posted

Use DateTime.Now.ToString("yyyy/MM/dd") 

https://docs.microsoft.com/en-us/dotnet/api/system.datetime.tostring?redirectedfrom=MSDN&view=netframework-4.8#System_DateTime_ToString_System_String_

using System;
					
public class Program
{
	public static void Main()
	{
		Console.WriteLine(DateTime.Now.ToString("yyyy/MM/dd"));
	}
}

//Output
2020/01/21

Answer 3

User-1971168174 posted

Thanks Yang for your reply!

Its not a single string, complete datatable column need to be converted to yyyy/mm/dd from (YYYY-MM-DDT00:00:00) format.

Answer 4

User-1780421697 posted

If you use this data table as data source of some data control like Gridview etc then you can apply this formatting at template level/field rendering. ELSE if you need formating of data table column then you can loop through it , get the column by name or id and update the format. 

If you have sql query to get data then you can format the date at SQL level , visit this for detail https://stackoverflow.com/questions/17205441/convert-date-format-into-dd-mmm-yyyy-format-in-sql-server