Last post Apr 22, 2011 09:10 AM by Lannie
Apr 22, 2011 03:07 AM|Thiyaguji|LINK
Hi friend i am trying to use Sqlite in 2008... tables are created correctly but date time is storing as "<Unable to read data>".. I dont know what
wrong is going
Apr 22, 2011 04:33 AM|smirnov|LINK
Try third-party tools, for example Sqliteadmin, or
Sqlite Database Browser.
Apr 22, 2011 09:10 AM|Lannie|LINK
Read SQLLite documentation on how to convert Date-Time to TEXT and display the date-time as TEXT in your ASP.NET grid.
In Oracle it would be
TO_CHAR(MY_DATE,'DD-MON-YYYY') AS MY_DATE_TEXT
MSSQL uses the CONVERT clause.