Re[2]: Date Problem

2004-03-09 Thread Richard Davey
Hello Peter, Wednesday, March 10, 2004, 12:16:51 AM, you wrote: PB> But that is adding two days, the original query was to add two PB> months, so presumably it should be "INTERVAL 2 MONTH" - but beware PB> that MySQL does some It should, sorry, I'm too used to the UK date format (even though I k

Re[2]: date problem

2003-03-23 Thread nobody
Hello Don, Well, you're right ;) I change the column type to int & it just run perfect. Thanks to both of ya! Monday, March 24, 2003, 5:21:35 AM, you wrote: DR> On 24-Mar-2003 Michael Shulman wrote: >> It looks like it's in now() format, but without the punctuation. The >> line >> from your in

Re[2]: date problem

2003-03-23 Thread nobody
Hello Michael, The most interesting part is that it's not in NOW() format! I've tried one-two times the same query and: mysql> select * from news; +++--+-++ | ID | author | title| text