From the dark recesses of my mind creeps the following information :

The OLE Variant Datetime is in fact a floating point number, whose integer part denotes the number of days since 31/12/1899, and whose fractional part denotes the part of a day.

So you could try to coax the Variant into a number, and either concatenate $value->Date() and $value->Time() in the hope that Time() only looks at the fractional part, or use that fractional number and convert it into seconds since the epoch by subtracting the number of days between 12/31/1899 and 31/12/1969 from it and some more date trickery.

Of course, the date range of the Variant is much higher than the number of seconds since the epoch, but your program won't be in use 2038 anyway, no ?

In reply to Re: Formatting Win32::OLE::Variant Dates by Corion
in thread Formatting Win32::OLE::Variant Dates by grinder

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.