powered by Jive Software

Logtime in ofmucconversationlog (mysql)


I am reading the logTime value in the ofmucconversationlog. This is of type varchar(15).

How can I transform this to a date?

This is an example of a value 001244557705264

I use .NET and tried to get transform it by

DateTime dt = new DateTime(logTime); //ticks

Doesnt this value represent the time the message was written?

Sorry I just found out why.

Java and .NET calclulate ticks based on different calenders

long d = logTime * 10000 + 621355968000000000L;

DateTime dt = new DateTime(d);

dt gives you the .NET time from the d java ticks