in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows
All Tags » DateTime (RSS)

Browse by Tags

  • Formatting date time in the where clause for an update query

    I am writingn an update query where I have to specify a date time value to correctly update the right row in a table. The date time is currently stored as 5/20/2008 12:00:00 AM. When I write my update query and use this particular date time, however, it does not update the row. My query looks like the...
    Posted to How To (Forum) by bd_epa on 03-05-2008

  • BOOLEAN type support

    The _typeNames in SQLiteConvert doesn't include support for "BOOLEAN". Also, there seem to be some incompatibilities in the formats of some things like DATETIME fields with the product SQLite Expert. (This may really be more of a feature request, but any help would be greatly appreciated...
    Posted to Bugs (Forum) by BondsBW on 12-07-2007

  • Best method for DateTime

    Hi, In my application, I use a lot of DateTime field. I have a lot of query which use a dateTime field. For example: - Select all data for a selected week - Select all data for a selected month, or year So, what is the best method to handle these query : -> Use a DateTime field, but with SQLite, function...
    Posted to How To (Forum) by Anguenot on 09-10-2007
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems