ho to change date and time format to insert into database?

[god_1896]

hi all;

i have found a code that would generate a time and date, this works fine,
my main goal is i want to change the date and time format.
here is the code that i found,

mysql_query("INSERT INTO mailrecord set date=CURDATE(), time=CURTIME()");

this format will output

CURTIME()  : 14:13:32
            CURDATE() : 2008-08-08

hope anyone can tell me where can i find a good source to output this format

CURTIME()  : 1:13:32pm
          CURDATE() : friday : 08 : 2008

[nav33n]

Use php's date function.
http://in2.php.net/date