[Trac] access to dates in Trac reports?

Matthew Good trac at matt-good.net
Tue Jun 7 07:45:31 CDT 2005


On Tue, 2005-06-07 at 17:59 +1200, Stephen Kestle wrote:
> >The dates in the database are stored as UNIX timestamps (the number of
> >seconds since 1 Jan 1970).
> >  
> >
> Will this be in UTC or local time zone?

UTC.

Refer to http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions for
information on SQLite's date/time functions.

-- 
Matthew Good <trac at matt-good.net>



More information about the Trac mailing list