About changing the format of date on server

Question

User1315566951 posted

Hello All,

I am using ASP.Net 3.5 with c#. And i am using ms access database. I have one table in which there is date column having the data type as datetime. Now i want to change the format of date columnn without data lost. Please suggest me any solution for this.

 

Thanks in Advance. 

Answer 1

User-1199946673 posted

Dates are not stored in a particular format in a database. Best practice is to format a date in the GUI (your webpage)

Answer 2

User3866881 posted

Hi priyankafanse：）

Use a GridView or something like data presentation control+AccessDataBase is a better choice，and then to use something like：

1）Eval("DateTimeColumnName","{0:yyyy/MM/dd}")

2）<asp:BoundField DataField="ColName" DataFormatString="{0:yyyy/MM/dd}"……/>