Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dsafar
  • Content: Threads
  • Order by date
  1. dsafar

    mysql and select if

    I have been able to get the following sql to work - &quot;select if(month(policydate)<=6),month(policydate),month(policydate)-6) as mth from mytable&quot;. I would like to be able to do the following &quot;select if(month(now()<6,(if(month(policydate)>6 ,month(policydate)-6,month(policydate)))...

Part and Inventory Search

Back
Top