Mysql OUTFILE Use System Date.txt

Below is my test.sh and my referral.sql now i want the .txt file to be named
the systemdate and the timestamp .txt

ex 20051009235959.txt somthing like that


test.sh
#!/bin/bash
/usr/bin/mysql -u root ehpadmin </usr/etc/referral.sql


referral.sql
SELECT * INTO OUTFILE '/tmp/referral.txt'
FIELDS TERMINATED BY ';' LINES TERMINATED BY '\N' FROM Referral_Authorization

my test.sh calls my referral.sql
thanks for help