Python Dates, Date-Time to Oracle

oracle_dt_utils.py

from datetime import date, datetime

def oracle_weekday(dt):
    '''
    Takes a python datetime or date object.
    Returns Day of Week in Oracle model
        Day   python  oracle
        Mon    0        2
        Tue    1        3
        Wed    2        4
        Thu    3        5
        Fri    4        6
        Sat    5        7
        Sun    6        1
    '''
    try:
        return (dt.weekday() + 2) % 8
    except:
        e = "oracle_weekday: Passed %r. Not a date or datetime object." % dt
        raise ValueError(e)

def oracle_dow_to_py_dow(oracle_day_of_week):
    try:
        return (int(oracle_day_of_week) - 2) % 7
    except:
        e = "oracle_dow_to_py_dow: Passed %r. Not an int" % oracle_day_of_week
        raise ValueError(e)