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

[Len Brown]

WARNING:

     Thankfully I am religious about making backups.  I made a backup of my
database just before asking about the time/date question.

     I just tried this twice to make sure it is not a quirk...

     I shut down OpenSim.  Then went into the database and changed the
"birthday" of my avatare to 1257076800 which is November 1, 2009 12:00:00
(noon).  I then saved the change in the database then restarted OpenSim.

Two things:

     My avatar is the default Ruth (with a birthday of Nov 1)

     My entire inventory is gone.

Again, thankfully I had a backup (whew!).  I shut everything down and
restored from backup twice - both times logging in and  my custom avatar was
intact.  Each time I changed the birthday in the database it turned my
avatar to Ruth and killed my entire inventory.

     I'm guessing "maybe" the issue is that the time stamp I gave the avatar
is prior to the time stamp when I actually set everything up - it was in the
late evening of Nov 1st.

     So at least I have a backup - so everything is running perfectly again.

     Any suggestions on why the date change for teh AV killed everything
else?

     Of note also - everything in-world was still there, and the textual
stuff I'd added to my avatar's profile was also intact.

- Len W. Brown
     lenwbrown at gmail.com
On Mon, Nov 2, 2009 at 1:32 PM, Len Brown <lenwbrown at gmail.com> wrote:

> Very cool and thank you very much.  Wow, I didn't expect such a quick
> reply.
>
> Much appreciated!
>
>   On Mon, Nov 2, 2009 at 1:31 PM, Chris Hart <Chris at codetorque.co.uk>wrote:
>
>>    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
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20091102/fb34af92/attachment.html>