|
|
| how to ckeck whether the date has expired |
Expert:nena
i have maintained a table(in postgres sql) where i have kept the records of product,customer & the date at which the product was sold. now, i want to display the list of customer whose licenced copy has expired. how to write the query for that?? or is their any other way?? |
| Answers |
Add one field in database 'expireDate' and put expire date of licenced copy in it.now compare current date with it, if current date is equal to expireDate or current date is greater than expire date, then it means licenced copy has expired.your query would be:
select *from tableName where(expDate==currentDate or expDate<currentDate)
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
