2009/3/13 John Machin <sjmac...@lexicon.net>: > 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 >
We use Trac; it seems to me that the number is in unixepoch. Use "DATE( due, 'unixepoch' )" to display the date in yyy-mm-dd format. Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users