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 | > > +

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 %h:%i:

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)