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 -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
