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
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
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
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
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 ?
___
5 matches
Mail list logo