[Opensim-users] How is "Date/Time" Recorded in the Database?

[Chris Hart]

Sounds like a timezone conflict between where your server thinks it is
and where your client thinks you are when it converts to human-readable
time.

 

The number in the database is Epoch time which means the time is nice
and universal and timezone-independant:

http://en.wikipedia.org/wiki/Unix_time

http://www.epochconverter.com/

 

Hope that helps,

Chris

 

From: opensim-users-bounces at lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Len Brown
Sent: 02 November 2009 7:27 PM
To: opensim-users at lists.berlios.de
Subject: [Opensim-users] How is "Date/Time" Recorded in the Database?

 

Hi Everyone!

 

     Do any of you know how OpenSim saves time in the database?

 

     Here's the situation - I started a brand new fully updated
"bleeding edge" OpenSim server at home on November 1st.  The region
shows it was created on Nov 1st but after creating a new skin, shape,
etc for my new avatar - I noticed my avatar profile says it was created
on November 2nd.

 

     In the database for my avatar is the following: 1257137090 to
represent when the avatar was created.  I suppose I could make the
number slightly smaller in the database and see what happens, but if
there is some "basic and simple" means that the current date is encoded,
what is it?  I want my avatar to also show a birthday of November 1,
like the region it's building...

 

Any hints?

 

Thanks!

 

- Len W. Brown

     lenwbrown at gmail.com 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.423 / Virus Database: 270.14.39/2468 - Release Date:
11/02/09 07:51:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20091102/3c0dd6a9/attachment.html>