In case you all missed it.

2011-11-11 Thread Curtis Maurand
mysql select date_format(now(),'%m-%d%-%y %h:%i:%s') AS time; +---+ | time  | +---+ | 11-11-11 11:11:11 | +---+ 1 row in set (0.00 sec)

Re: In case you all missed it.

2011-11-11 Thread Mark Goodge
On 11/11/2011 16:29, Curtis Maurand wrote: mysql select date_format(now(),'%m-%d%-%y %h:%i:%s') AS time; +---+ | time | +---+ | 11-11-11 11:11:11 | +---+ 1 row in set (0.00 sec) Actually, it should be select date_format(now(),'%y-%m%-%d

Re: In case you all missed it.

2011-11-11 Thread Chris Tate-Davies
On Fri, 2011-11-11 at 16:38 +, Mark Goodge wrote: On 11/11/2011 16:29, Curtis Maurand wrote: mysql select date_format(now(),'%m-%d%-%y %h:%i:%s') AS time; +---+ | time | +---+ | 11-11-11 11:11:11 | +---+ 1 row in set