Hi,
I have gotten a file from a customer that contains the date time in VMS format, and a separate file that contains the date time format in DD-MMM-YYYY HH:MM:SS.MS
I need to convert the date format(DD-MMM-YYYY HH:MM:SS.MS) in the one file to link to the date format in the other, to create a database, and run code against it.
Example:
2nd file
16-MAR-2004 14:53:30.85
equivalent vms time in first
45861656108500000
More examples:
16-MAR-2004 14:58:43.68 45861659236800000
19-NOV-2002 08:59:11.32 45444131513200000
I searched everywhere for how to achieve in VB, or how the readable date time equates to VMS, and the only thing I could find is:
100 ns granularity, 64 bit tick counter since ?Smithsonian base date? 00:00 17-Nov-1858
So it looks like I would need a formula to count 100ns from Nove-17-1858 to the date/time in the 2nd file. I have no clue where to start, or if vb can count in Nanoseconds. Please help
I have gotten a file from a customer that contains the date time in VMS format, and a separate file that contains the date time format in DD-MMM-YYYY HH:MM:SS.MS
I need to convert the date format(DD-MMM-YYYY HH:MM:SS.MS) in the one file to link to the date format in the other, to create a database, and run code against it.
Example:
2nd file
16-MAR-2004 14:53:30.85
equivalent vms time in first
45861656108500000
More examples:
16-MAR-2004 14:58:43.68 45861659236800000
19-NOV-2002 08:59:11.32 45444131513200000
I searched everywhere for how to achieve in VB, or how the readable date time equates to VMS, and the only thing I could find is:
100 ns granularity, 64 bit tick counter since ?Smithsonian base date? 00:00 17-Nov-1858
So it looks like I would need a formula to count 100ns from Nove-17-1858 to the date/time in the 2nd file. I have no clue where to start, or if vb can count in Nanoseconds. Please help