Hi, On Fri, Jan 16, 2009 at 9:46 PM, Sean Dague <[email protected]> wrote: > J Ross Nicoll wrote: >> Any chance of a number of times accessed field for assets, in addition >> to the access_time field? >> >> While I'm looking at the assets table, is there any specific reason >> why creation/access times are stored as integers rather than using >> actual date & time types? > > Because storing time as number of seconds since epoch is a tried and > true technique, and is used throughout the opensim source base, so is > consistant with how it is done elsewhere.
Another reason I can think of is that an integer is supported identically in most (all?) databases. The datetime datatypes may be different, making data migration from SQLite to MySQL a little more complicated, for instance. Mike _______________________________________________ Opensim-dev mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-dev
