Posted by Captain Paralytic on 10/12/06 12:39

iulian.ilea@gmail.com wrote:

> Hi,
>
> I use MsSQL server. I created an application in PHP who uses a field
> type datetime. When I tested it local it worked fine, the datetime
> field has this format: mm/dd/yyyy. When I tested it on another server I
> remarked that the same field datetime has format dd/mm/yyyy. How can I
> change it to mm/dd/yyyy.

MySQL stores dates in an internal format that looks nothing like dd or
mm or yyyy.

When you perform a query, you can decide how you want a date formatted
by using the DATE_FORMAT() function.

See: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[Back to original message]