How is 2/12/2003 13:31 = 3E4A 9301 ?

Here's another one. Again, I can't seem to google specifically enough for it, so perhaps someone can point me in the right direction.

http://www.vbforums.com/attachment.p...postid=1363250

And, Thanks Keda for the last one. The Double Precission IEEE 754 is extremely fascinating, and from a compression viewpoint, has some interesting implications.

The textdate correlates with the numeric date, if you count by seconds (it's 8 seconds of, but did you get the correct time for the textdate?). Just look at the difference from both ( Numeric diff= 247688 ; Textdate diff 68:48 hrs in seconds 247680 ).
If you use 365days/year the 0 would be 1.1.1970
And the HEX value is just the same as Numeric just in Hex

You're right.
The Hex is the same as the numeric.
I created the numeric from the hex.

So, in this instance, the only algorythm I would need would be an accurate seconds to Date mapper, takeing into consideration leap years.

Thanks!
:)

-Lou

How dates are stored internally varies by OS or database.

For example in Windows:
File date & time is a quadword (two longs). It is the number of milliseconds since Jan 1, 1970.

In VMS:
File date & time is a quadword, starting Nov 17, 1858.

In Oracle: DATE datatype is
An octaword milliseconds starting from 01-JAN-4712 BC - time zero for the standard Julian calendar

In other words, there is NO portability for any kind of date
variable processing fromsystem to system.

Quote:

---

In Oracle: DATE datatype is
An octaword milliseconds starting from 01-JAN-4712 BC - time zero for the standard Julian calendar

---

I'm wondering what they did measure in milliseconds back in 4712 BC ;-)

Well, That was simple!

The complete Text Date, as viewed in a text log file created by the job logger, of which extracts the data from the binary logging files that I'm cracking, were:

2/12/2003 13:31 ==> "Job Submission Date = February 12, 2003 13:31:29"
2/15/2003 10:19 ==> "Print Completion Date = February 15, 2003 12:30:51"

so, useing the full "Job Submission Date" as an initial anchor, and useing the DateAdd function, subtracting the seconds value of that date, I create a Date_Zero base.

Then, adding the seconds value of the "Print Completion Date" that I extracted out of the Binary data file to the Date_Zero, I do indeed get "Saturday, Feb 15 2003, 10:19:37 AM", exactly what I want.

cool!
:)

VB Code:

Private Sub Command1_Click()
    MsgBox Format(DocuSP_Date("1045322377"), "dddd, mmm d yyyy, hh:mm:ss AMPM")
End Sub
 
 
Private Function DocuSP_Date(ByVal In_Secs As String) As Date
Dim Date_Zero As Date
Dim Ref_Date As Date
Dim Ref_Secs As String
    Ref_Date = CDate("February 12, 2003  13:31:29")
    Ref_Secs = "-1045074689"
    Date_Zero = DateAdd("s", Val(Ref_Secs), Ref_Date)
    DocuSP_Date = DateAdd("s", Val(In_Secs), Date_Zero)
End Function