如何筛选当前日期值表单Sql [英] How Do I Filter Current Date Valued Form Sql

问题描述

亲爱的朋友们，



我的数据库有简单的表格，如下所示。我需要过滤EPF_Numbers只有当前日期

Dear friends,

My Database has simple table as below. i need to filter EPF_Numbers only current date

SELECT EPF_Number FROM Lunch ORDER BY DATE

以上查询给出了表格中的所有数据。如何过滤当前日期。任何人都可以帮助我





table column = ID，EPF_Number，COUT，DATE，TIME

above query gives all the data in a table. how can i filter current date.anyone can help me


table column = ID ,EPF_Number, COUT, DATE ,TIME

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

如果今天是2015-06-19 resutl shoud be

if today is 2015-06-19 resutl shoud be

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

这篇关于如何筛选当前日期值表单Sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！