1. strange time and date format
I have this
Time='49440000' Date='731038'
how can I convert it to time and date?
2. strange time and date format
This is strange:
(all times are in same day)
(hour:minute)
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!!
3. Re: strange time and date format
See another message I sent ...
----- Original Message -----
From: "Derek Parnell" <Derek.Parnell at SYD.RABOBANK.COM>
To: "EUforum" <EUforum at topica.com>
Subject: RE: strange time and date format
>
> Ummmm. A bit more info would be nice.
>
> Like ...
> where did you get this data from?
> what date and time do you think this represents?
>
>
> > -----Original Message-----
> > From: 10963508 at europeonline.com [mailto:10963508 at europeonline.com]
> > Sent: Tuesday, 23 July 2002 11:57
> > To: EUforum
> > Subject: strange time and date format
> >
> >
> > I have this
> > Time='49440000' Date='731038'
> > how can I convert it to time and date?
> >
> >
> ==================================================================
>
>
> ==================================================================
>
>
>
>
4. Re: strange time and date format
----- 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.
