mssql date format

[MRAB]

On 2016-09-13 00:06, sum abiut wrote:
> Thanks for the response,
> i pulling data from an mssql database and i need to convert the date 
> column. how to i covert and pass it to my template. i am using Django
>
> this is what i did
>
> conn=pymssql.connect(server,username,password,database)
>     #cus=conn.cursor()
>     cus=conn.cursor(as_dict=True)
>     cus.execute("SELECT 
> account_code,currency_code,balance_date,debit,credit,net_change,home_net_change 
> FROM glbal where account_code= '50101001CORP'    ")
>
>     return render_to_response('revenue_budget.html',locals())
>
>
> how to i  convert the balance_date with the code below:
>
>
>
>             import datetime
>             datetime.datetime.fromordinal(733010)
>
> datetime.datetime(2007, 11, 30, 0, 0)
>
>
The documentation for pymssql should tell you how to get the values of 
the fields.

In the case of the 'balance_date' field, just pass its value into 
datetime.datetime.fromordinal like the code I gave.