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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.