Re: [sqlalchemy] Working with func in dates, No response, no error message

2023-04-04 Thread Nancy Andeyo
I am still struggling to find the solution on this issue, the issue is with the func, because when I omit the comparison with the the func sqlachemy function, the outcome is expected. However, I want to ensure that only items for this month are displayed: he filter *.filter(func.strftime('%m',

Re: [sqlalchemy] Working with func in dates, No response, no error message

2023-04-04 Thread Nancy Andeyo
I am still struggling to find the solution on this issue, the issue is with the func, because when I omit the comparison with the func sqlalchemy function, the outcome is expected. However, I want to ensure that only items for this month are displayed: he filter *.filter(func.strftime('%m',

Re: [sqlalchemy] Working with func in dates, No response, no error message

2023-03-30 Thread James Paul Chibole
Thank you Philip for your suggestion. On Thursday, March 30, 2023 at 9:38:08 PM UTC+3 Philip Semanchuk wrote: > > > > On Mar 30, 2023, at 2:32 PM, James Paul Chibole > wrote: > > > > Hi everyone, I am trying to retrieve deceased persons who died in the > current month but the output gives no

Re: [sqlalchemy] Working with func in dates, No response, no error message

2023-03-30 Thread Philip Semanchuk
> On Mar 30, 2023, at 2:32 PM, James Paul Chibole wrote: > > Hi everyone, I am trying to retrieve deceased persons who died in the current > month but the output gives no result. Here is my code with query done in > Python Flask: > from datetime import datetime