SQL question

If I sent this to the wrong address, please forgive me. I lost all my e-mail and settings and have been trying to get everything set back up.

Anyway,
I'm trying to get a date to print from the following select statement, that is 14 days prior to the current date and have it print out in date format Feb 27, 2002. Can anyone tell what I'm doing wrong??

&run_statement("select subdate('date_format(now('CURRENT_DATE'), '%b %e, %Y') CURRENT_TIME', interval '-14 0:0' day_minute);");

     while(($begin_date) = $sth->fetchrow){

            print "$begin_date";
}

Thanks,
Marian Received on Thu Feb 28 2002 - 02:14:02 CET