Date Format - I Know Sore Subject!

[Anon]

Hi Everyone,
First off I have read my books and did some surfing. I still cannot get the date to display as such "07 Aug 2002". It keeps displaying "2002-08-07" when I query, which the way it is stored in MySQL. However I would like it to display 07 Aug 02. The server is running on a NT environment with IIS4.

Any inputs would be gratefully appreciated.

:o) Ivan

[Anon]

Ivan,

There should be some functions in the MySQL SQL interpreter to allow you to set the date format. You should try to conver the date format in MySQL (using that function in the SQL statement), and not in PHP.

I have written scripts designed to work in any ODBC-compliant DB, and I've discovered that using the DB's native Date/Time datatype is not always the best solution.

Instead, I use a 14 char field for storing dates, and use the format YYYYMMDDHHMMSS. This allows to rapidly "see" the date when browsing the tables, by using a single Select statement, and to rapidly "sort" dates using a simple "ORDER BY" predicate in any SQL statement. Also, allows to program indpendently from any date/time function the DB Administrator might have.

Erich