getting the values of datediff.

[bazz]

Hi,

I query my db for DATEDIFF and use a fetchrow->hashref. datediff should return a value but what should I use to get them into the hashref?


(SELECT ps.min_adults
, ps.image
, datediff(end_date,$arrival_date_requested)+1 as days_overlap
from rooms
) or die.....

while ( my $room = $get_room_numbers->fetchrow_hashref)
{
my $min_adults = $room->{min_adults};
my $days_overlap = $room->{days_overlap};
my @days_overlap = (split /,/, $days_overlap);

}


printing out @days_overlap gives me nothing.

bazz

[bazz]

sokay. I have got values to return but since they are wrong, I need to change my datediff sections.

bazz