Member Avatar for M.Waqas Aslam

Hello Every One !

I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date ,

can any one help me:(

Regards

M.Waqas Aslam

  • 2 Contributors
  • 2 Replies
  • 206 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for pritaeas

Have a look at DATEDIFF().

Member Avatar for M.Waqas Aslam

Have a look at DATEDIFF().

thanks , it works for me , :) thank you so much

Regards

M.Waqas

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.