🔒 a continue of my other thread about datetime and how i can fix my problem

[cobalt mortar]

this is a continuation of the #1239108117258833920
thread im using asqlite version 2.0.0a0

[forest grove]

@cobalt mortar

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[cobalt mortar]

and this is some of the problems i mentioned

and i want to get the time if it is equal to the users input which this part those

raw_date = f"{year}-{month}-{day}"
date = dt.strptime(raw_date, '%Y-%m-%d').date()
print(date)
 
#the part which fetches from database
fetch_server_data = """SELECT message FROM msg_logging WHERE user_id = ? AND server_id = ? AND date = ?"""
await cursor.execute(fetch_server_data,(user.id, interaction.guild.id, int(date)))```
my db

[raw hollow]

idk sql but that date looks like either an str or a date if that exists there if its an str turn it into an str else find how u format it to the date it accepts

[white gale]

why are you converting date to an int?

[forest grove]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.