1
Answer

date month year

vikas kanani

vikas kanani

12y
829
1
how to compare current date with database stored many dates.if any 1 stored date is match with current date print same date.if store date is same month or same year then print expiry date is near..please help if know.
Answers (1)
0
Sukesh Marla

Sukesh Marla

NA 11.8k 1.2m 12y
Use getDate() to get the current date
Example
Select getdAte()

Use DatePart to extract month and year
example
select DAtePart(mm,getDate())


Use Case statement as

Select case when a=1 and b=1 then cast(DateStoredInDatabase as varchar) else
'exp date' end from MyTable


Check this is correct answer if it helped.