Jump to content


Photo

Dates form sql


  • Please log in to reply
2 replies to this topic

#1 avo

avo
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • Locationstaffordshire uk

Posted 02 July 2006 - 10:12 PM

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 sense

a few example of this would be great

All appriciated
Im loving it ........

#2 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 03 July 2006 - 04:20 AM

first off, what date datatype are you using? date? time? datetime? timestamp?

2nd, can you be a little more clearer with this:

select all from the row where month interval + 2 months to whats in the coloum

do you mean from like, now to now+2months? or timeA to timeA+2months?

Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#3 avo

avo
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • Locationstaffordshire uk

Posted 03 July 2006 - 05:59 AM

Hi thanks its date im using

i wish to select all from tble_name where date_coloum is same as date(today) less ( - ) 2 months

how would this be write for sql to unserstand the select


hope that explanes a little better

Thanks in advance
Im loving it ........




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users