DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: trace Epoch Time and convert

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    trace Epoch Time and convert

    The developers here pass in dates through JDBC using Epoch Time (time in millisecs after 1970). I am trying to debug/tune a page that passes in a date using Epoch Time.

    Unfortunately, when I trace this stuff, the bind variable for the date looks like this:
    PHP Code:
     bind 3dty=180 mxl=11(11mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=16 offset=0
       bfp
    =ffffffff7ca11de8 bln=11 avl=11 flg=05
       value
    =
    Dump of memory from 0xFFFFFFFF7CA11DE8 to 0xFFFFFFFF7CA11DF3
    FFFFFFFF7CA11DE0                   78680205 0F2A1B05          
    [xh...*..]

    FFFFFFFF7CA11DF0 2F83C070                             [/..p
    So, how do I figure out what ACTUAL date the application is passing in?
    Naturally I don't want to just take the developers word for it. I want to prove it.

    Is the '78680205' above the Epoch time?
    If not, how can I figure out what date is being passed in?
    - Cookies

  2. #2
    Join Date
    Feb 2004
    Posts
    50
    What level of tracing are you using?

    The entry for 'value=' should show the value.
    From the trace shown, it doesn't look like anything has been assigned to the bind variable (yet). Look further down the trace file, towards the bottom. You may see the value there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width