It seems that perls local::time function returns the day
of the month as 1-31 whereas postgres returns it as 01-31.
I need to compare dates
if 2004-1-12 (from perl) less than 2004-01-19 (from postgres) and its failing.
Is there a way to have perl return day of the month as
a 2 digit string or some code to automaticly pad it?
I am using
# Get current time and date
($mday,$mon,$year)=(localtime(time + (24*60*60)))[3..5];
$dstr1 = "$year-$mon-$mday";
Thanks for any ideas,
pgsql-novice by date
|Next:||From: hodges||Date: 2004-01-11 17:27:09|
|Subject: Re: date comparison between perl and postgres|
|Previous:||From: Dario Ottaviano||Date: 2004-01-11 09:43:30|
|Subject: Case sensitivity|