in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
System.Data.SQLite » SQLite ADO.NET Provider » How To » Change DateTime Format On Insert

Change DateTime Format On Insert

Last post 02-10-2010 5:21 AM by alex21. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next

  • 02-10-2010 5:21 AM

    Change DateTime Format On Insert

    Reply Contact

     I am using datatables to make large changes to my database, however the datatable class is changing the format of the date, so that when i try to access the data i get the classic "String is not a valid DateTime" error.

     So i am wondering if there is some SQL that i can use in an INSERT statement to convert the DateTime back to the format it needs to be in to avoid SQLite crashes.

     Thanks

    Filed under:
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems