avo Posted July 2, 2006 Share Posted July 2, 2006 HI can anyone please point me in the right dirrection with an example ive been looking at the sql manual but struggling to find what i need i have a sql table with a few date coloums i would like to select all from the row where month interval + 2 months to whats in the coloum if this makes sensea few example of this would be great All appriciated Quote Link to comment Share on other sites More sharing options...
.josh Posted July 3, 2006 Share Posted July 3, 2006 first off, what date datatype are you using? date? time? datetime? timestamp? 2nd, can you be a little more clearer with this:[b]select all from the row where month interval + 2 months to whats in the coloum [/b]do you mean from like, now to now+2months? or timeA to timeA+2months? Quote Link to comment Share on other sites More sharing options...
avo Posted July 3, 2006 Author Share Posted July 3, 2006 Hi thanks its date im usingi wish to select all from tble_name where date_coloum is same as date(today) less ( - ) 2 monthshow would this be write for sql to unserstand the select hope that explanes a little better Thanks in advance Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.