Re: strange time and date format
- Posted by 10963508 at europeonline.com Jul 22, 2002
- 361 views
----- Original Message ----- From: "Derek Parnell" <Derek.Parnell at SYD.RABOBANK.COM> To: "EUforum" <EUforum at topica.com> > > 12:50 is represented with 39000000 -- ok > > 15:32 is represented with 48720000 -- ok > > 17:47 is represented with 56820000 -- ok > > 1:28 is represented with 84480000 -- !!this is strange!! > > They all look strange to me. Why are the three you marked okay? I cannot > work out the formula you have applied to derive the time. i used datetime.e and got difference between 12:50 and 0:0 and multiplied that with 1000 to get milliseconds and it matched with that strange number, only some offset was left. the last case (1:28) it turned out to be hour of the next day, not same day, so that must be bug in program i got installed. > And I repeat my previous question: Where did you get this data from? i got it from some database which uses some other program which is installed on my computer.