Format a long value to a date time value

[jluis_hdezg]

Could anyone explain to me how to format a long value as a date time value?. This is because I am using Btrieve as a data base and the datetime fields are store as long types. Any help is greatly apreciated. Regards, :)

[Dustin Metzgar]

Oh, btrieve, I'm sorry. We, unfortunately, also use btrieve here. But our dates are stored as a string. Probably because it's just a date and not a datetime. Do you know if the long represents seconds or milliseconds? There's probably also a starting date like 1/1/1980 or 1/1/1900. If you had this information you could probably have a constant defined for the start date and just use the AddSeconds or AddMilliseconds methods to add the long value.

---

Logifusion[^]

[Larantz]

If the Ticks for Btrieve equals Ticks for the System.DateTime then you can use this:

DateTime theTime = new DateTime(_longValue);

Otherwise you'd have to find out what the startday is for Btrieve and if it counts in milliseconds or nanoseconds etc, then modify the returnvalue to equal the format for System.DateTime before using the above codesnippet. -Larantz-

for those about to code, we salute you