[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
  DateTime::Format::MySQL->format_datetime($dt);


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?
 Thanks!

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


More information about the Catalyst mailing list