PDA

View Full Version : [jadmin] jabberd2 dates?


ReK2
05-21-2008, 08:33 PM
the dates on jabberd2 mysql tables are weird..or maybe I am weird lol in
any case
I need help..
for example on the status table on the time column:
1128290840
are those seconds?

Thanks.
_______________________________________________
JAdmin mailing list
JAdmin (AT) jabber (DOT) org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
_______________________________________________

Peter Saint-Andre
05-21-2008, 08:36 PM
On 05/21/2008 12:27 PM, ReK2 wrote:
> the dates on jabberd2 mysql tables are weird..or maybe I am weird lol in
> any case
> I need help..
> for example on the status table on the time column:
> 1128290840
> are those seconds?

Probably seconds since the beginning of the Unix era.

/psa



_______________________________________________
JAdmin mailing list
JAdmin (AT) jabber (DOT) org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
_______________________________________________

ReK2
05-21-2008, 09:06 PM
Peter Saint-Andre escribió:
> On 05/21/2008 12:27 PM, ReK2 wrote:
>
>> the dates on jabberd2 mysql tables are weird..or maybe I am weird lol in
>> any case
>> I need help..
>> for example on the status table on the time column:
>> 1128290840
>> are those seconds?
>>
>
> Probably seconds since the beginning of the Unix era.
>
> /psa
>
>
Thanks going to try and code a converter.
_______________________________________________
JAdmin mailing list
JAdmin (AT) jabber (DOT) org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
_______________________________________________

Timm Wimmers
05-21-2008, 10:28 PM
ReK2 schrieb:

> Thanks going to try and code a converter.

Eh? Why coding, is allway there:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

--
Timm

_______________________________________________
JAdmin mailing list
JAdmin (AT) jabber (DOT) org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
_______________________________________________

ReK2
05-21-2008, 10:46 PM
Timm Wimmers escribió:
> ReK2 schrieb:
>
>> Thanks going to try and code a converter.
>
> Eh? Why coding, is allway there:
>
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
>
ohh cool , thanks.!
_______________________________________________
JAdmin mailing list
JAdmin (AT) jabber (DOT) org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
_______________________________________________