On 12/03/2009 12:21 AM, Nicolás Solá wrote: > Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB > schema there is a table called “milestone”. It has a field called “due” and > it means due date. The problem is that it uses an integer data type to store > the datum and I don’t know how to show it in a SELECT query as datetime. Can > anyone help me please?
Help us to help you: tell us more about this date stored as integer. (1) the integer is the number of days since what date? or (2) some examples e.g. 2008-12-31 is represented as 123456 2009-01-01 is represented as 123457 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
