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?
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.