mssql date format

[Chris Angelico]

On Mon, Sep 12, 2016 at 11:15 AM, MRAB <python at 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