I am using MySQL to keep record of apointment times. MySQL keeps time in 24hour military time (00:00:00). I would like to change this to 12hour time to display it in my application. I know that dreamweaver 8 can convert date formats but I cannot find one to change time. Is there a function to change this format in dreamweaver or a way to do it in MySQL? Thanks.

JPunisher

Hi Javier

What server-side script are you using?

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

The formatting of the date is done by your script, what are you using, asp, php etc?

Regards,

sdm