You build pretty much any format you desire out of those speifiers. ie:
select date_format(now(),'%m/%c/%Y');
- md
On Thu, May 6, 2010 at 5:00 PM, Weydson Lima wrote:
> I was referring to the function:
>
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-forma
Thank you for your explanation. I was just curious if there was an "easy"
way to format the output of the dates.. maybe by using a wildcard
expression on the field names :)
Weydson Lima
On May 7, 2010 3:08am, Johan De Meersman wrote:
Dates are not internally stored as a specific region for
Dates are not internally stored as a specific region format, they're stored
as seconds since epoch - just a big number.
Output formatting is a presentation layer issue, which you can solve either
in your SQL [select date_format(datefield, 'us format string') from table]
or in your application.
Ma
I was referring to the function:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format
---
Weydson Lima
weys...@gmail.com
On Thu, May 6, 2010 at 1:58 PM, Martin Gainty wrote:
> http://lists.mysql.com/commits/60834
>
> date_format system variable is currentl
