date comparison between perl and postgres

Поиск
Список
Период
Сортировка
От hodges@xprt.net
Тема date comparison between perl and postgres
Дата
Msg-id 400114E1.24922.298B074@localhost
обсуждение исходный текст
Ответы Re: date comparison between perl and postgres  (hodges@xprt.net)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: One big database or little separate ones?
Следующее
От: hodges@xprt.net
Дата:
Сообщение: Re: date comparison between perl and postgres