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 по дате отправления