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?

If it does, it's a """proleptic Gregorian ordinal, where January 1 of year 1 has ordinal 1""" (from the docs):

import datetime
datetime.datetime.fromordinal(733010)
datetime.datetime(2007, 11, 30, 0, 0)

--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to