date comparison between perl and postgres

Поиск
Список
Период
Сортировка
Искать
От
hodges@xprt.net
Тема
date comparison between perl and postgres
Дата
Msg-id
400114E1.24922.298B074@localhost
Список
Дерево обсуждения
date comparison between perl and postgres hodges@xprt.net
Re: date comparison between perl and postgres hodges@xprt.net
Re: date comparison between perl and postgres Bruno Wolff III <bruno@wolff.to>
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];
$mon ++;
$year +=1900;
$dstr1 = "$year-$mon-$mday";

Thanks for any ideas,

Tom Hodges
hodges@xprt.net
В списке pgsql-novice по дате отправления
От:
Дата:
От: hodges@xprt.net
Дата:
FAQ