I have following [RestaurantOffer] table. Offers, which is valid only within two date ranges (i.e FromDate and ToDate) and at a particular timing(FromTime,ToTime).
So I want to write a query which would give me all Offers on current date(Today) and the time will be more than current Time(Today's Current Time). Because I don't want to get the expired Offers.
Database :
FromDate(date),
ToDate(date),
FromTime(time),
ToTime(time)
Aucun commentaire:
Enregistrer un commentaire