Posts by Guilherme Cunha • 37 points
4 posts
-
0
votes1
answer22
viewsA: Mysql - How to select previous month’s records?
Hello! Try it like this: SELECT Id, Name, Createdate FROM Clients WHERE Createdate >= DATE_ADD(SYSDATE(), INTERVAL -1 MONTH)
-
0
votes1
answer30
viewsA: INNER JOIN with 3 sql tables
Try removing the second table in your "FROM". Leave only "FROM tbl_cupom_generated" and try to execute the code.
-
2
votes2
answers1618
viewsA: Date conversion problem (DD/MM/YYYY to YYYY-MM-DD) with 'pd.to_datetime()' - Python
After a few attempts, I was able to solve the problem by forcing the format during the conversion with pd.to_datetime(): Previous: valido_ate = pd.to_datetime(valido_ate) Correct: valido_ate =…
-
-3
votes2
answers1618
viewsQ: Date conversion problem (DD/MM/YYYY to YYYY-MM-DD) with 'pd.to_datetime()' - Python
I’m starting in the world of Python and I’m trying to develop a simple code to identify the expiration period of digital certificates where I work (it’s a personal project, but taking advantage of a…