[Dbix-class] InflateColumn::DateTime - how to use it?
RA Jones
ra.jones at dpw.clara.co.uk
Thu May 10 13:17:45 GMT 2007
Sigh. I thought this one was going to be easy. Convert MySQL's native
date format (yyyy-m-d) to EU-style (dd-mm-yyyy):
In Schema::Request
__PACKAGE__->load_components(qw/PK::Auto Core InflateColumn::DateTime/);
__PACKAGE__->add_columns( qw/id some_more_columns/ );
__PACKAGE__->add_columns( date => { data_type => 'date' } );
In controller:
while ( my $hits = $rs->next ) {
push @hits, [
$hits->date, # OK
$hits->date->year, # not OK:
"Can't call method "year" without a package or object reference at ... "
Presumably I've missed something not documented in the POD?
On reflection though, maybe InflateColumn is not the correct method for
what I really want - to globally reformat date fields to EU format.
--
Richard Jones
Leeds, UK
**********************************************************************
This message may contain confidential and privileged information.
If you are not the intended recipient please accept our apologies.
Please do not disclose, copy or distribute information in this e-mail
or take any action in reliance on its contents: to do so is strictly
prohibited and may be unlawful. Please inform us that this message has
gone astray before deleting it. Thank you for your co-operation.
NHSmail is used daily by over 100,000 staff in the NHS. Over a million
messages are sent every day by the system. To find out why more and
more NHS personnel are switching to this NHS Connecting for Health
system please visit www.connectingforhealth.nhs.uk/nhsmail
**********************************************************************
More information about the Dbix-class
mailing list