[thelist] MySQL date format
Hassan Schroeder
hassan at webtuitive.com
Mon Nov 28 13:02:26 CST 2005
Symeon Charalabides wrote:
>>Of course this format fails to take into account the last day of the
>>month or year (giving you e.g. Saturday, 31 - 1 December 2005), so you
>>would probably need to improve this. All in all, it's usually better to
>>use PHP (or whatever) to format your dates for ouput.
>
> True, this is what I ended up doing. I was wondering if it was possible to bring
> up such a string (or some variation thereof) with a simple SELECT, as it's faster
> than digging up the conventional date, then formatting it with PHP. As it turns
> out this isn't possible as the SELECT needed is so complex that PHP probably does
> it faster.
Not necessarily, but you never answered the question -- what do
you expect the output for e.g. '2005-11-30' to look like?
--
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
More information about the thelist
mailing list