View Ticket
Not logged in
Ticket UUID: 06479b05aaee45f1a0f32fad97576155494256a5
Title: Date Format in DataGrid
Status: Closed Type: Incident
Severity: Cosmetic Priority: Zero
Subsystem: LINQ Resolution: Rejected
Last Modified: 2012-12-22 21:37:12
Version Found In:
User Comments:
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?


mistachkin added on 2012-12-22 21:37:12:
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.