Re: comparring dates between perl and postgres - Mailing list pgsql-novice

hodges@xprt.net wrote:

>I am getting a field of date type from PostgreSQL and an
>integer that is a number of days (1 to 3).
>
>select date, num_days from table
>$date, $num_days
>
>In my perl script I am getting the current date
>
>#find current date
>($mday,$mon,$year,$doy)=(localtime(time))[3..5,7];
>$mon ++;
>$year +=1900;
>$today = "$year-$mon-$mday";
>
>

I dont know about perl but Postgresql will do it for you as
mypromt:#SELECT EXTRACT(DOY FROM DATE '2003-12-25')
date_part
----------------------
359

1 Row(s) affected

Shoot back if this helps !

Regards,
V Kashyap