Re: mssql date format

2016-09-12 Thread Nathan Ernst
Note that this issue is mentioned in the pymssql FAQ: http://pymssql.org/en/stable/faq.html#pymssql-does-not-unserialize-date-and-time-columns-to-datetime-date-and-datetime-time-instances Regards, Nathan On Mon, Sep 12, 2016 at 8:29 PM, Dennis Lee Bieber wrote: > On Tue, 13 Sep 2016 00:52:59 +0

Re: mssql date format

2016-09-12 Thread 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.cu

Re: mssql date format

2016-09-12 Thread sum abiut
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)

Re: mssql date format

2016-09-11 Thread Chris Angelico
On Mon, Sep 12, 2016 at 11:15 AM, MRAB wrote: > On 2016-09-12 01:37, sum abiut wrote: >> >> Hi, >> I am pulling data from an mssql server database and got a date in this >> format: 733010 >> please advise what of date is this and how to i convert it to a readable >> date? >> >> i use pyssql to con

Re: mssql date format

2016-09-11 Thread MRAB
On 2016-09-12 01:37, sum abiut wrote: Hi, I am pulling data from an mssql server database and got a date in this format: 733010 please advise what of date is this and how to i convert it to a readable date? i use pyssql to connect to the database and pull data fro the database. Does the date "

mssql date format

2016-09-11 Thread sum abiut
Hi, I am pulling data from an mssql server database and got a date in this format: 733010 please advise what of date is this and how to i convert it to a readable date? i use pyssql to connect to the database and pull data fro the database. thanks in advance, cheers -- https://mail.python.org/m