in

System.Data.SQLite

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

Browse by Tags

Sorry, but there are no more tags available to filter with.
  • Select year data from a DateTime field

    Hello, I have a datetime field (mydate) in my table (mytable), and I want to get all different year from this table. Here is the query which works in MySQL : string queryString = "Select distinct year(mydate) as year from mytable" I want to make the same query using SQLite I have try this ...
    Posted to How To (Forum) by Anguenot on 09-06-2007
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems