BTV Time

[,red589]

When I access the API for upcoming shows I get an xml file showing me everthing I need to know. The only problem is the times. Any time referance looks like this, 127644840000000000, How do I change this to a standard date and time?

[deria]

To decode time values, do this:

Dim RecordingStart As DateTime
Dim RecordingEnd As TimeSpan

' Get the start time of the recording, adjusted to local time.
RecordingStart = RecordingStart.FromFileTimeUtc(BTV_Recording_Prope rty.Value)
RecordingStart = RecordingStart.ToLocalTime()

' Get the span of the recording.
RecordingEnd = RecordingEnd.FromTicks(CLng(BTV_Recording_Property .Value))

The code above assumes that you've already gotten the property out of the property bag. If not, do something like this:

(excuse the formatting, this board makes a mess of it)

Dim BTV_RecentRecordings_ProperyBagArray() As I_BTV_Scheduler.PVSPropertyBag = BTV_Scheduler.GetRecentRecordings()

If BTV_RecentRecordings_ProperyBagArray.Length = 0 Then
' There are no recent recordings.
Debug.WriteLine("No recent recordings found.")
Else
For Each BTV_RecentRecording As I_BTV_Scheduler.PVSPropertyBag In BTV_RecentRecordings_ProperyBagArray

For Each BTV_RecentRecording_Property As I_BTV_Scheduler.PVSProperty In BTV_RecentRecording.Properties

...the code from the first section of this post...
Next
Next
End IF

[,red589]

unfortunately I'm not using .net so that won't help me very much. I just need to know what the system is based on and I can hopefully translate it.

[Kilrsat]

Its either a windows timestamp, in ticks, or a .net DateTime object in ticks. I believe its the windows timestamp, but I'll give you both definitions.

fileTime is a 64-bit signed integer value representing a Windows file timestamp. The timestamp is the number of 100-nanosecond intervals that have elapsed since January 1, 1601 A.D. (C.E.) 12:00 A.M. coordinated universal time (UTC).

DateTime.Ticks:
The value of this property is the number of 100-nanosecond intervals that have elapsed since 12:00 A.M., January 1, 0001.

[deria]

As Kilrsat said.

I believe that its #1 (a 64-bit signed integer value equal to the number of 100ms intervals sicnd 1-1-1601 00:00 UTC.

Decoding that will be annoying, I'm sure, since you will need to probably resolve that value to years, months, days, hours, minutes, seconds, and milliseconds and then use whatever date library you have available to you to add those values to 1-1-1601 00:00. Alternatively, if your date library is good, it might allow you to work with the filetime structure directly.

[queler]

Here's a non .NET solution in VBA/VB6 [addon] BTV Command Line Tools