Re: Timestamp in the trace files

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 06 Jan 2010 21:10:56 +0100
Message-ID: <4B44EE50.8030701_at_gmail.com>

On 06.01.2010 21:02, Maxim Demenko wrote:

> On 06.01.2010 20:27, Mladen Gogala wrote:

>> On Wed, 06 Jan 2010 19:37:14 +0100, Maxim Demenko wrote:
>>
>>> On 06.01.2010 19:02, Mladen Gogala wrote:
>>>> On Wed, 06 Jan 2010 17:40:43 +0000, Mladen Gogala wrote:
>>>>
>>>>> I am analyzing a trace file and the developer asked me when has this
>>>>> event taken place:
>>>>>
>>>>> =====================
>>>>> PARSING IN CURSOR #3 len=159 dep=0 uid=141 oct=3 lid=141
>>>>> tim=1233122414291746 hv=3402358638 ad='9a174550' select
>>>>> folderarti0_.segment# as col_0_0_, folderarti0_.FOLDER# as col_1_0_
>>>>> from FOLDER_ARTICLES folderarti0_ where folderarti0_.segment# in (:1 ,
>>>>> :2 , :3 , :4)
>>>>> END OF STMT
>>>
>>
>> This is not really helpful. The application has run on 05-Jan-2009. Here
>> is what I get when I try using "seconds from 1970":

>> The result is January 28th, 2009, which is almost a year off.
>>

>
> DATE'1970-01-01'+(1
> -------------------
> 05.01.2010 18:49:12
>
>
> Best regards
>
> Maxim
>

Sorry, of course, i am interpreting your words like it better suit my needs ;-)
But either your meant to say "The application has run on 05-Jan-2010" - in that case my previous post still applies, or it run indeed on 05-Jan-2009 and my math is wrong, but then it is unclear with "The result is January 28th, 2009, which is almost a year off".

Best regards

Maxim Received on Wed Jan 06 2010 - 14:10:56 CST