in reply to Re: ADO Date Problems
in thread ADO Date Problems

When I de-reference it, I get a number (days since 1970), not a date time string. thanks for your response.

Replies are listed 'Best First'.
Re: Re: Re: ADO Date Problems
by CountZero (Bishop) on Dec 19, 2002 at 19:57 UTC

    I admit I never used WIN32::OLE with ADO.
    I always access databases (of whatever kind) with DBI and DBD which is much more portable and clean.

    I saw that on CPAN there are a number of modules supporting ADO, even a DBD-ADO module, so perhaps you could consider changing to DBI and DBD-ADO.

    Of course that leaves your question still unanswered.

    Now, I am a bit intrigued by yoru reference to ADO returning a hash-reference. Are you sure it is a hash-reference and not a reference to a simple scalar? It looks a bit wasteful to me to return one number through a hash instead of a scalar.

    Anyhow, did you try feeding the number of days to the localtime-function? If you call that function in scalar context you get a string with the date and time.
    If you call that function in list context, you get a list with sec, min hour, day, month, year weekday and two more things called '$yday' and '$isdst' (beats me what they are).

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law