Hi I have a sub routine listed at end.  I request you to kindly tell me the mistake in 
this.

I am not able to split the the string "12.12.1975" on the "." seprator.  

also when  I try ot repace the dot with some other variable useing the statement 
$date=~s/./#/g;

It is repalcing all the charcters including the dots.  

I wonder if we need to use any specail technique to use split or regs with "."

regards

Rajeev


#########################################################################
#                                                                                      
                                       #
# Converting the date into sql date format                                             
                      #
#                                                                                      
                                       #
#########################################################################

sub sqlDate{
 
 my $date = shift; 
 #$date=~s/./#/g;
 
 #--- rearranging the date months and year values into sql format yyyy/mm/dd.
 my ($day, $month, $year) = split(".",$date); 
 my $sqldate = "$year/$month/$day";
 
 &ds("date = $date", "$day, $month, $year", " sqldate = $sqldate");
 
 return $sqldate;

}

Reply via email to