Filter data from pd.read_sql_query

Viewed 21

I'm using 'pd.read_sql_query' to extract the data from microsoft sql in python. However, when I'm trying to filter specified row from the query, it show blank/ no result.

sql = pd.read_sql_query('''

                SELECT * FROM table
                       
                 ''', conn) 


df = pd.DataFrame(sql)


given = '02/03/2022'

given = datetime.strptime(given, '%d/%m/%Y')


dff = df[df['Date'] == given]

print(dff)

What is the issue?

0 Answers
Related