Re: select timestamp + 0

e string shown above converted into a number is 2005. > ( Unless you think ist should be 1988 ) > Add 0, and it is still 2005. > > >and also : > > > >select timestamp as timestamp from news limit 1; > >+-+ > >| timestamp | > &g

Re: select timestamp + 0

) Add 0, and it is still 2005. and also : select timestamp as timestamp from news limit 1; +-+ | timestamp | +-+ | 2002-03-25 19:45:32 | +-+ so If I do : select timestamp + 0 as timestamp from news limit 1

Re: select timestamp + 0

| +-+ | 2002-03-25 19:45:32 | +-+ so If I do : select timestamp + 0 as timestamp from news limit 1; ++ | timestamp | ++ | 20020325194532 | ++ So i would expect a "max(timestamp) + 0" to work the same th

Re: select timestamp + 0

Mister Jack wrote: Hi, i'm using the 4.1.10 version of mysql. If I do : select max(timestamp + 0 ) as timestamp from news; ++ | timestamp | ++ | 20050314194920 | ++ so i got the full timestamp(14), but if I do : select max(timestamp) + 0 as times

select timestamp + 0

Hi, i'm using the 4.1.10 version of mysql. If I do : select max(timestamp + 0 ) as timestamp from news; ++ | timestamp | ++ | 20050314194920 | ++ so i got the full timestamp(14), but if I do : select max(timestamp) + 0 as timestamp from news;