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

[Len Brown]

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/9f9b8040/attachment.html>