SELECT EPF_Number FROM Lunch ORDER BY DATE
4 56 1 2015-06-17 23:22:05.7900000 5 7 1 2015-06-17 23:24:01.7070000 6 43 1 2015-06-19 00:28:34.7770000 7 12 1 2015-06-19 09:09:39.1030000
6 43 1 2015-06-19 00:28:34.7770000 7 12 1 2015-06-19 09:09:39.1030000
SELECT EPF_Number FROM Lunch WHERE DATE=GETDATE() ORDER BY DATE --GETDATE() WILL GIVE BOTH CURRENT DATE AND TIME --- --CONVERT(DATE, GETDATE()) WILL GIVE CURRENT DATE SELECT EPF_Number FROM Lunch WHERE DATE=CONVERT(DATE, GETDATE()) ORDER BY DATE ----- --IF YOUR DATE IS A VARCHAR COLUMN SELECT EPF_Number FROM Lunch WHERE DATE=CONVERT(VARCHAR(10), GETDATE(), 111) ORDER BY DATE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)