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

  • Question

  • User-1971168174 posted


    Is there no way we can covert entire datatable column having datetime in the format (YYYY-MM-DDT00:00:00) to format ( YYYY/MM/DD ).

    Any sample using Linq or any other way will be great help.


    Wednesday, January 22, 2020 3:42 AM


All replies

  • User-1780421697 posted
    using System;
    using System.Data;
    using System.Linq;
    using System.Data.DataSetExtensions;
    public class Program
    	public static void Main()
                   // Create a new DataTable.    
                    DataTable dt = new DataTable("tbl");  
                    DataColumn dtColumn;  
    		dtColumn = new DataColumn();  
    		dtColumn.DataType = typeof(DateTime);  
    		dtColumn.ColumnName = "CreatedDate";  
    		DataRow dr = dt.NewRow();
    		dr["CreatedDate"] = DateTime.Now;
    		DataRow dr1 = dt.NewRow();
    		dr1["CreatedDate"] = DateTime.Now.AddDays(1);
    		var query = dt.AsEnumerable()
    			.Select(r => r.Field<DateTime>("CreatedDate").ToString("yyyy/MM/dd"));
    		foreach (var r in query)

    Output is:


    //this is just for an idea that you can create anonymous object and then reuse it.

    Wednesday, January 22, 2020 5:40 AM
  • User288213138 posted


    convert DataTable entire column to YYYY/MM/DD format without for-loop...

    Can you tell me where the data comes from?

    If there are in a database, you can try the following code:

    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
                string query = "SELECT * FROM DateTable";        
                    using (SqlConnection con = new SqlConnection(constr))
                        using (SqlCommand cmd = new SqlCommand(query, con))
                            SqlDataReader sdr = cmd.ExecuteReader();
                            while (sdr.Read())
                                string s1 = Convert.ToString(sdr["Date"]);
                                DateTime value;
                                DateTime.TryParse(s1, out value);
                                Label1.Text = value.ToString("yyyy-MM-dd");

    Best regards,


    Wednesday, January 22, 2020 6:12 AM
  • User409696431 posted

    How are you populating the DataTable?  If from an SQL Server database you can format the date in the query.  https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver15

    Wednesday, January 22, 2020 6:37 AM
  • User-1971168174 posted

    Thanks for your reply!

    Data is coming from API, I need to convert entire column in datatable without using for loop.

    Wednesday, January 22, 2020 8:23 AM
  • User-1780421697 posted

    Clearly You cannot change the DataType after the Datatable is filled with data, however there are some tech to deal with update or clone of data table. Please find the link there is an extension that do conversion for you.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 22, 2020 10:35 AM