Re: [SPAM]Re: Select distinct year from unix timestamp

2004-05-16 Thread Paul DuBois
At 0:25 +0200 5/17/04, John Fawcett wrote: From: "Paul DuBois"> At 22:27 +0200 5/16/04, John Fawcett wrote: >Year does not operate on a unix timestamp. Sure it does: mysql> select t, year(t) from tsdemo1; ++-+ | t | year(t) | ++-+

Re: [SPAM]Re: Select distinct year from unix timestamp

2004-05-16 Thread John Fawcett
From: "Paul DuBois"> At 22:27 +0200 5/16/04, John Fawcett wrote: > >Year does not operate on a unix timestamp. > > Sure it does: > > mysql> select t, year(t) from tsdemo1; > ++-+ > | t | year(t) | > ++-+ > | 20010822133241 |2001 | >