hodges(at)xprt(dot)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