How to convert a string to a datetime?

I'm trying to run a row query with objects. I have a tran_date field which is look like: '2022062519:14:47' I think because of that I'm getting this error:

django.db.utils.DataError: date/time field value out of range: "2022062519:22:54" LINE 1: ...HERE merch_id = '510000022048730' and tran_date = '202206251...

Here is my code:

medium_prob = ProcessTransaction.objects.raw('SELECT * '
                                                                 'FROM bvb_generaltransaction '
                                                                 'WHERE merch_id = %s and tran_date = %s::DATE '
                                                                 'and probabilty >= 0.8 and alerted= false',
                                                                 [str(merchant.merch_id), str(merchant.tran_date)])

How can I solve that?

Back to Top