利用python筛选出当天的数据

Question

 

import pymssql
import pandas as pd
###连接sql sever并读取数据到dataframe
conn = pymssql.connect('fghdfhgn', 'sa', 'hgjfhg', '57574')
cursor = conn.cursor()

#########读取当天的数据###
sql = 'select * from RSS where FDate=2018-11-21'
test = pd.read_sql(sql, conn)

DatabaseError: Execution failed on sql 'select * from RSS where FDate=2018-11-21': (206, b'Operand type clash: date is incompatible with intDB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the SQL Servern')
##############

sql = '''select * from RSS where FDate(checktime,'%Y-%m-%d')=2018-11-21'''
test = pd.read_sql(sql, conn)
DatabaseError: Execution failed on sql 'select * from RSS where FDate(checktime,'%Y-%m-%d')=2018-11-21': (195, b"'FDate' is not a recognized built-in function name.DB-Lib error message 20018, severity 15:nGeneral SQL Server error: Check messages from the SQL Servern")

####
sql = 'select * from RSS where to_days(FDate) = to_days(now())'
test = pd.read_sql(sql, conn)

DatabaseError: Execution failed on sql 'select * from RSS where to_days(FDate) = to_days(now())': (195, b"'to_days' is not a recognized built-in function name.DB-Lib error message 20018, severity 15:nGeneral SQL Server error: Check messages from the SQL Servern")
########
sql = 'SELECT * FROM RSS where DATEDIFF(day,inputdate,GETDATE())=0'

test = pd.read_sql(sql, conn)
DatabaseError: Execution failed on sql 'SELECT * FROM RSS where DATEDIFF(day,inputdate,GETDATE())=0': (207, b"Invalid column name 'inputdate'.DB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the SQL Servern")
#############

出错信息：DatabaseError: Execution failed on sql 'select * from RSS where datediff(day,ordTime,getdate()-1)=0 ': (207, b"Invalid column name 'ordTime'.DB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the SQL Servern")

Answer 1

 没有加入列

sql = 'select * from RSS where DateDiff(dd,FDate,getdate())=0'