<div>Very cool and thank you very much. Wow, I didn't expect such a quick reply.</div>
<div> </div>
<div>Much appreciated!<br><br></div>
<div class="gmail_quote">On Mon, Nov 2, 2009 at 1:31 PM, Chris Hart <span dir="ltr"><<a href="mailto:Chris@codetorque.co.uk">Chris@codetorque.co.uk</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-GB" vlink="purple" link="blue">
<div>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">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.</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">The number in the database is Epoch time which means the time is nice and universal and timezone-independant:</span></p>
<p class="MsoNormal"><a href="http://en.wikipedia.org/wiki/Unix_time" target="_blank">http://en.wikipedia.org/wiki/Unix_time</a><span style="COLOR: #1f497d; FONT-SIZE: 11pt"></span></p>
<p class="MsoNormal"><a href="http://www.epochconverter.com/" target="_blank">http://www.epochconverter.com/</a><span style="COLOR: #1f497d; FONT-SIZE: 11pt"></span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">Hope that helps,</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt">Chris</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt" lang="EN-US">From:</span></b><span style="FONT-SIZE: 10pt" lang="EN-US"> <a href="mailto:opensim-users-bounces@lists.berlios.de" target="_blank">opensim-users-bounces@lists.berlios.de</a> [mailto:<a href="mailto:opensim-users-bounces@lists.berlios.de" target="_blank">opensim-users-bounces@lists.berlios.de</a>] <b>On Behalf Of </b>Len Brown<br>
<b>Sent:</b> 02 November 2009 7:27 PM<br><b>To:</b> <a href="mailto:opensim-users@lists.berlios.de" target="_blank">opensim-users@lists.berlios.de</a><br><b>Subject:</b> [Opensim-users] How is "Date/Time" Recorded in the Database?</span></p>
</div>
<div>
<div></div>
<div class="h5">
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi Everyone!</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal"> Do any of you know how OpenSim saves time in the database?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal"> 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.</p>
</div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal"> In the database for my avatar is the following: <strong>1257137090</strong> 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...</p>
</div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Any hints?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Thanks!</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">- Len W. Brown</p></div>
<div>
<p class="MsoNormal"> <a href="mailto:lenwbrown@gmail.com" target="_blank">lenwbrown@gmail.com</a> </p></div></div></div>
<p><span style="FONT-SIZE: 10pt">No virus found in this incoming message.<br>Checked by AVG - <a href="http://www.avg.com/" target="_blank">www.avg.com</a><br>Version: 8.5.423 / Virus Database: 270.14.39/2468 - Release Date: 11/02/09 07:51:00</span></p>
</div></div><br>_______________________________________________<br>Opensim-users mailing list<br><a href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br></blockquote></div><br>