Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-24 Thread Giuseppe Costanzi
as others have suggested you strftime('%d-%m-%Y', mytalbe.myfield) regards beppe On Wed, Mar 19, 2014 at 10:39 PM, Stefano Ravagni wrote: > Hello, i'm new in SQLite develop... > > i'n a gridview (.NET) i visualize the data type in -MM-DD format > > Using others database i ever see dat

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Simon Slavin
On 20 Mar 2014, at 2:19pm, Stefano Ravagni wrote: > I know, in facts i use a TEXT field...so you intend datagrid usually > understand if the field is or not a DATE field showing the value in > auto-formatted way ? SQLite does not have a DATE datatype and does not understand dates at all. You

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Stefano Ravagni
I know, in facts i use a TEXT field...so you intend datagrid usually understand if the field is or not a DATE field showing the value in auto-formatted way ? If this is the explanation, is not a big problemthanks for reply ! Il 20/03/2014 13.31, Kees Nuyt ha scritto: On Wed, 19 Mar 2014 14

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Kees Nuyt
On Wed, 19 Mar 2014 14:39:39 -0700 (PDT), Stefano Ravagni wrote: >Hello, i'm new in SQLite develop... > >i'n a gridview (.NET) i visualize the data type in -MM-DD format > >Using others database i ever see data in format which follow culture >setting (italian in this case)... but not in

[sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Stefano Ravagni
Hello, i'm new in SQLite develop... i'n a gridview (.NET) i visualize the data type in -MM-DD format Using others database i ever see data in format which follow culture setting (italian in this case)... but not in SQLite.. How could i solve ? ___