Extracting date from the sql query string in python

Question

I have a case where I have to extract date from a SQL query that I am running through a python script.

This is the query:

select * from COLL_DS2 where TRANSACTION_DATE between '2021.02.28' and '2021.04.08' order by CREATION_DATE

I want to extract '2021.02.28' and '2021.04.08' from the query string.

Any help please? Thanks in advance

Can you please share your code for better understanding

Burakhan Aksoy
– Burakhan Aksoy

2021-04-11 08:22:14 +00:00
Commented Apr 11, 2021 at 8:22 — Burakhan Aksoy
– Burakhan Aksoy, Commented Apr 11, 2021 at 8:22

Laurent B. · Accepted Answer · 2021-04-11 14:32:16Z

1

Another way to write it. Tim Biegeleisen solution is good, just need to add the import re

import re
Query = "select * from COLL_DS2 where TRANSACTION_DATE between '2021.02.28' and '2021.04.08'"
ldat = re.findall('\d+\.\d+\.\d+', Query)

print(ldat)
# ['2021.02.28', '2021.04.08']

edited Apr 11, 2021 at 14:32

answered Apr 11, 2021 at 9:45

Laurent B.

2,3032 gold badges10 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

amitesh shukla Over a year ago

Yes, this one working. Thanks. In the above solution, I was getting an empty array.I already had re imported. I think it was because of r in the "re.findall" line which was causing the problem.

Tim Biegeleisen Over a year ago

This is not the best or safest answer which can be given, because the regex pattern used here would match things like IP addresses e.g. 192.168.0.1 in addition to dates.

Laurent B. Over a year ago

You are right for IP adresses but on the other hand you have also many format for dates : 2021.4.8, 21.4.8 etc...

Tim Biegeleisen · Accepted Answer · 2021-04-11 08:22:24Z

1

You may use re.findall:

sql = "select * from COLL_DS2 where TRANSACTION_DATE between '2021.02.28' and '2021.04.08' order by CREATION_DATE"
dates = re.findall(r"'(\d{4}\.\d{2}\.\d{2})'", sql)
print(dates)  # ['2021.02.28', '2021.04.08']

answered Apr 11, 2021 at 8:22

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

3 Comments

amitesh shukla Over a year ago

Sorry it's returning an empty list.

Tim Biegeleisen Over a year ago

@amiteshshukla No it's not.

amitesh shukla Over a year ago

I think it was because of r in the "re.findall" line which was causing the problem. The below answer is the updated version of your answer. But that one worked for me. So marked that one as right and upvoted your answer. Thanks for giving the solution though. Much appreciated @Tim Biegeleisen

Collectives™ on Stack Overflow

Extracting date from the sql query string in python

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related