need to add date in the file name into outfile caluse below please suggest

SET @outpath = "/var/lib/mysql-files/";
SET @outfile = (SELECT NOW());
SET @outextension = "_StepCount.csv";
SET @SQL := CONCAT("Select Concat(ifnull(First_Name,'')," ",ifnull(Middle_Name,'')," ",ifnull(Last_name,'')) AS Name, u.email from users",@outpath,@outfile,@outextension ) ;
PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

I have an form having following fields are populated by sql server 2000 Name, age, dob,phonenumber,date,accountnumber and this data is stored into sql server now I want this data will be output to an ASCII text file. How can i do this and for the same plz provied me the code.