mardi 21 juin 2016

Display a date that is the same as today in SQL Server [duplicate]

This question already has an answer here:

I have a table named Test and I want to display the info only from the current date.

I tried to do something like this but doesn't work if I use =

SELECT * FROM Test WHERE graduated = GETDATE()

And here is the table

------------------------------------------------
|  id         |  name           | graduated           |
------------------------------------------------
| 1      | John          | 2016-06-20         |
------------------------------------------------
| 2      | Amy          | 2016-06-20         |
------------------------------------------------
| 3      | Lily          | 2016-06-21         |
------------------------------------------------

Aucun commentaire:

Enregistrer un commentaire