On Mon, Sep 12, 2016 at 11:15 AM, MRAB <pyt...@mrabarnett.plus.com> 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 connect to the database and pull data fro the database. >> > Does the date "30 November 2007" look reasonable for that data?
And if it doesn't, try selecting now() from the database, which should give you today's date and time. Possibly cast that to the same type of date that you're working with. If that gives you an easily readable result, you may have some kind of custom "date stored as integer" field, which you'd have to discuss with your DB admin. ChrisA -- https://mail.python.org/mailman/listinfo/python-list
