<?xml version="1.0" encoding="windows-1252"?>
<node id="614229" title="Answer: How do I convert date format between 'DD-MM-YYYY' and 'YYYY-MM-DD' back &amp; forth?" created="2007-05-08 15:39:01" updated="2007-05-08 11:39:01">
<type id="1888">
categorized answer</type>
<author id="11732">
QandAEditors</author>
<data>
<field name="doctext">
The following answer uses regexes.

&lt;code&gt;
# UK-style
my $in_date = '30-04-2007';
(my $db_date = $in_date) =~ s/(\d\d)-(\d\d)-(\d\d\d\d)/$3-$2-$1/;
(my $pr_date = $db_date) =~ s/(\d\d\d\d)-(\d\d)-(\d\d)/$3-$2-$1/;
print "in: $in_date; db: $db_date; pr: $pr_date\n";
# in: 30-04-2007; db: 2007-04-30; pr: 30-04-2007
&lt;/code&gt;

&lt;code&gt;
# US-style
my $in_date = '05-14-2007';
(my $db_date = $in_date) =~ s/(\d\d)-(\d\d)-(\d\d\d\d)/$3-$1-$2/;
(my $pr_date = $db_date) =~ s/(\d\d\d\d)-(\d\d)-(\d\d)/$2-$3-$1/;
print "in: $in_date; db: $db_date; pr: $pr_date\n";
# in: 05-14-2007; db: 2007-05-14; pr: 05-14-2007
&lt;/code&gt;

Instead of rolling your own, some [cpan://CPAN modules] might help, such as [cpan://Date::Tiny], [cpan://Date::Formatter], or [cpan://Date::Simple]. They look promising but I haven't tried them myself.</field>
<field name="parent_node">
614222</field>
</data>
</node>
