[Dbix-class] Pointless update on a date field
Matt S Trout
dbix-class at trout.me.uk
Mon Sep 17 22:03:38 GMT 2007
On Mon, Sep 17, 2007 at 08:26:05PM +0100, Richard Jones wrote:
> Jason Kohles wrote:
> >>How then do I do something like $schema->update( \%form_data ) when
> >>the user submits a date formatted as '20/12/2000'. How would you do it
> >>with the US equivalent '12/20/2000'?
> >As I understand it, you have a date_to_mysql() method that takes a
> >variety of different date formats and turns them into mysql formatted
> >dates, what you should probably do is turn that into a
> >date_to_datetime() method, that returns a DateTime object instead of a
> >mysql-formatted date. In my case I just use HTML::FormFu with an
> Right, all appears to work OK if I use a date_to_datetime() method
> instead of a date_to_mysql() one. But in one sense I don't really gain
> much as I still have to manually parse the users' date input to create a
> datetime object, ie
> instead of date_to_mysql():
> return join '-', Decode_Date_EU($date);
> I have:
> my ($yr, $month, $day) = Date::Calc::Decode_Date_EU($date);
> return DateTime->new( year => $yr, month => $month, day => $day);
There's almost certainly a DateTime::Format module that'll do better than
that - the strptime one for a start. Trying to use Date::Calc stuff to get
to DateTime objects is always going to be more work since you're now hand
linking two separate projects with incompatible APIs.
I often use Time::ParseDate which gets me an epoch value then construct a
DateTime object from that (and it'll usually DWIM however the date's supplied)
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director http://www.shadowcat.co.uk/catalyst/
Shadowcat Systems Ltd. Want a managed development or deployment platform?
More information about the DBIx-Class