[Catalyst] DateTime::Format::MySQL

Meeko meeko.lists at gmail.com
Thu Dec 30 00:10:58 GMT 2010

I'm having a problem with DateTime::Format::MySQL, and was wondering if
anyone could help.  I have timestamps stored in a MySQL database, and am
trying to use this module to create a DateTime object with them.

According to the module documentation, the usage is:

  use DateTime::Format::MySQL;

  my $dt =3D DateTime::Format::MySQL->parse_datetime( '2003-01-16 23:12:01'=

  # 2003-01-16 23:12:01

In my code, I have a variable called $ts, which I have verified matches the
proper format by displaying it to the screen, like this:

$ts contains: 2010-12-28 21:45:29

However, when I add in the following code:

my $formatted_date =3D DateTime::Format::MySQL->parse_datetime($ts);

I get the following error:

Caught exception in MyApp::Controller::Root->index "The following
parameter was passed in the call to DateTime::new but was not listed
in the validation options: local_rd_secs

I have tried googling for this error, but can't seem to find the answer.
 Can anyone provide me with any insight as to what this error means?

- Meeko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20101229/2b5cc=

More information about the Catalyst mailing list