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.
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.
>
I'd recommend you store the date as yyyy-mm-dd, which is unambiguous.
Mick
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-functio ns.html