in reply to ADO Date Problems

Is there a problem with dereferencing the hash-reference?

CountZero

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

Replies are listed 'Best First'.
Re: Re: ADO Date Problems
by Anonymous Monk on Dec 19, 2002 at 15:58 UTC
    When I de-reference it, I get a number (days since 1970), not a date time string. thanks for your response.

      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