Subversion Repositories SmartDukaan

Rev

Rev 104 | Rev 122 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 104 Rev 115
Line 35... Line 35...
35 
        current_from_date = to_py_date(from_date)
35 
        current_from_date = to_py_date(from_date)
36 
    if to_date:
 36 
    if to_date:
37 
        current_to_date = to_py_date(to_date)
 37 
        current_to_date = to_py_date(to_date)
38
38
39 
    return  current_status, current_from_date, current_to_date
 39 
    return  current_status, current_from_date, current_to_date
- 
 
 40 
 
- 
 
 41 
def get_mssql_date(date):
- 
 
 42 
    mssql_date_year = str(date.year)
- 
 
 43 
    if date.month < 10:
- 
 
 44 
        mssql_date_month = "0%d"%(date.month)
- 
 
 45 
    else:
- 
 
 46 
        mssql_date_month = str(date.month)
- 
 
 47
- 
 
 48 
    if date.day < 10:
- 
 
 49 
        mssql_date_day = "0%d"%(date.day)
- 
 
 50 
    else:
- 
 
 51 
        mssql_date_day = str(date.day)
- 
 
 52
- 
 
 53 
    mssql_date = "%s%s%s"%(mssql_date_year,mssql_date_month, mssql_date_day)
- 
 
 54 
    return int(mssql_date)
- 
 
 55 
 
- 
 
 56 
def get_mssql_time(date):
- 
 
 57 
    mssql_date_hour = str(date.hour)
- 
 
 58 
    if date.minute < 10:
- 
 
 59 
        mssql_date_minute = "0%d"%(date.minute)
- 
 
 60 
    else:
- 
 
 61 
        mssql_date_minute = str(date.minute)
- 
 
 62
- 
 
 63 
    if date.day < 10:
- 
 
 64 
        mssql_date_second = "0%d"%(date.second)
- 
 
 65 
    else:
- 
 
 66 
        mssql_date_second = str(date.second)
- 
 
 67
- 
 
 68 
    mssql_date = "%s%s%s"%(mssql_date_hour,mssql_date_minute, mssql_date_second)
- 
 
 69 
    return int(mssql_date)
40 

            70