Timestamp formats

[torvalen]

Hello

When I list my table in Navicat or MyPHPadmin, I get the desired Date Time format (2009-06-07 09:00:00).
When I create a Recordset in Dreamweaver I get an unwanted Date Time format (Sun Jun 7 09:00:00 UTC+0200 2009 ).
How I retain the date format that MySql spit out?
Why does the format suddenly change when i make a recordset in Dreamweaver? I think that I have set the character set and encoding right in both database and application.

BR. Tor valen

 

[r937]

you ~could~ generate a date string with the exact desired format tight in the SQL, using the DATE_FORMAT function

a better solution would be to tell Dreamweaver how to format the date

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon