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 problem....thanks for reply !
Il 20/03/2014 13.31, Kees Nuyt ha scritto:
On Wed, 19 Mar 2014 14:39:39 -0700 (PDT), Stefano Ravagni
<stefanorava...@gmail.com> wrote:
Hello, i'm new in SQLite develop...
i'n a gridview (.NET) i visualize the data type in YYYY-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 ?
SQLite has no type "date".
If you see "YYYY-MM-DD", it is stored as type TEXT, in exactly that
format (and that is always correct everywhere, because ISO8601 is the
international standard).
You can use one of the date formatting functions in your select
statement to change the presentation.
http://sqlite.org/lang_datefunc.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
