|Title:||Date Format in DataGrid|
|Last Modified:||2012-12-22 21:37:12|
|Version Found In:||188.8.131.52|
anonymous added on 2012-12-22 09:43:37:
I have a C# 4.0 application and I am using the sqlite provider to access to a sqlite data base. When I use application like Sqlite Administrator to make some query, the format of the date fields is dd/mm/yyyy. But I I use entity framework in myt C# application and I show the information in the datagrid, the date format is mm/dd/yyyy HH:MM:SS. I would like to show the date with the dd/mm/yyyy or better yyyy/mm/dd format, without the hour. Is it possible? Thanks. Daimroc.
mistachkin added on 2012-12-22 21:37:12: (text/x-fossil-plain)
The format of the DateTime column in a DataGrid has a lot more to do with the .NET Framework than System.Data.SQLite. There are four primary DateTime formats that System.Data.SQLite knows about: 1. (Ticks) The number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001. 2. (ISO8601) String conforming to "yyyy-MM-dd HH:mm:ss.FFFFFFFK", etc. 3. (JulianDay) The integer assigned to a whole solar day in the Julian day count starting from noon Greenwich Mean Time, with Julian day number 0 assigned to the day starting at noon on January 1, 4713 BC proleptic Julian calendar. 4. The integer number of whole seconds since the Unix epoch. These are the DateTime formats that are understood by the internal conversion routines in System.Data.SQLite; however, the output format for display is something else entirely.