Nevermind, I fixed my own problem. It was a stupid mistake on my part (they usually are)<div><br></div><div>My problem was actually further down in my code. After getting my $formatted_date object from DateTime::Format::MySQL, I was mistakenly trying to create a new DateTime object with it, not realizing that $formatted_date is already the DateTime object that I needed. After taking that out, and using $formatted_date like I should have to begin with, its working now.</div>
<div><br></div><div>- Meeko<br><br><div class="gmail_quote">On Wed, Dec 29, 2010 at 7:10 PM, Meeko <span dir="ltr"><<a href="mailto:meeko.lists@gmail.com">meeko.lists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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.<div><br>
</div><div>According to the module documentation, the usage is:</div><div><br></div><div><pre> use DateTime::Format::MySQL;
my $dt = DateTime::Format::MySQL->parse_datetime( '2003-01-16 23:12:01' );
# 2003-01-16 23:12:01
DateTime::Format::MySQL->format_datetime($dt);</pre></div><div><br></div><div>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:</div>
<div><br></div><div><pre>$ts contains: 2010-12-28 21:45:29</pre></div><div><br></div><div>However, when I add in the following code:</div><div><br></div><div>my $formatted_date = DateTime::Format::MySQL->parse_datetime($ts);</div>
<div><br></div><div>I get the following error:</div><div><br></div><div><pre><code>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
</code></pre></div><div><br></div><div>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!</div><div><br></div><font color="#888888"><div>
- Meeko</div>
</font></blockquote></div><br></div>