locked
REG : SQlite in vs2010 RRS feed

  • Question

  • User-1045328190 posted

    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

    Friday, April 22, 2011 3:07 AM

Answers

  • User269602965 posted

    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.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 22, 2011 9:10 AM

All replies

  • User1508394307 posted

    Try third-party tools, for example Sqliteadmin, or Sqlite Database Browser.

    Friday, April 22, 2011 4:33 AM
  • User269602965 posted

    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.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 22, 2011 9:10 AM