my $time = convert_tim(1068837428812901);
print "Epoch $time\n", scalar gmtime $time, "\n";
# Seem to need a conversion factor of 976,562.5 is 1,000,000,000/1024
sub convert_tim {
my $factor = 1_000_000_000/1024;
return $_[0]/$factor;
}
__DATA__
Epoch 1094489527.10441
Mon Sep 6 16:52:07 2004
Now the plaintext date in your log was 20040906 11:52:07.103 so we get the date right, and the minute and second (down to 5 sig figs). This would appear to be a little to improbable for it to be a coincidence. I expect your DB GMT offset is 5 which is why the hours are out.
