Update script with current date in python

Question

I need some assistance updating a SQL script file with the current date. E.g. from python. In the SQL script I have a from->to date filter. To get this month's records. I will run this script from a CRON job on a Linux machine. And need to automatically update the from and to dates.

How?

;SQL script text to update. Before running sqlite3 shell command.
...
and date(tc1.time,'unixepoch')
   BETWEEN date('2012-03-01','start of month')
  and date('2012-04-01','start of month','+1 month','-1 day')
and date(tc2.time,'unixepoch')
 BETWEEN date('2012-03-01','start of month')
   and date('2012-04-01','start of month','+1 month','-1 day')

If date system date is 2012-03-30.

>date +"%Y-%m-%d"
2012-03-30

I wish to get from 2012-03-01 to 2012-04-01. If the date is 2012-04-20 or 2012-04-21.. I wish the output from 2012-04-01 to 2012-05-01.

Any suggestions?

kossmoboleat · Accepted Answer · 2012-03-30 08:36:55Z

1

This should do the trick:

import datetime
d=datetime.date.today()
start_current_month=datetime.date(d.year,d.month,1)

if d.month==12:
    new_year=d.year+1
    new_month=1
else:
    new_year=d.year
    new_month=d.month+1

start_next_month=datetime.date(new_year,new_month,1)

str_start_current_month=start_current_month.isoformat()
str_start_next_month=start_next_month.isoformat()

str_start_current_month=start_current_month.isoformat()
str_start_next_month=start_next_month.isoformat()

answered Mar 30, 2012 at 8:36

kossmoboleat

1,9612 gold badges21 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Update script with current date in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related