<div>
The value you provided does not make sense to me as a date and time, nor as a unix timestamp. Can you please explain to what date and time does this value correspond?
</div>


The value you provided does not make sense to me as a date and time, nor as a unix timestamp. Can you please explain to what date and time does this value correspond?

<div>
I also felt like that at first look as it is of length 18 digits long. But after browsing the net I found that there is possibility that the timestamp has been storing in this format in some DBs.<br />
<br />
212099645407486318 is mostly nearby to the time 2009-Jan-25 12:16:00 GMT<br />
<br />
I'm not sure about exact equivalent of time for the value given.<br />

</div>


I also felt like that at first look as it is of length 18 digits long. But after browsing the net I found that there is possibility that the timestamp has been storing in this format in some DBs.

212099645407486318 is mostly nearby to the time 2009-Jan-25 12:16:00 GMT

I'm not sure about exact equivalent of time for the value given.


<div>
<div class="content wysiwyg-content">
I have file with contents retrieved from mysql DB.<br />
which has a time field with type defined bigint(20)<br />
I want to parse that field into timestamp format(YYYY-MM-DD HH:MM:SS GMT) using python code.<br />
The value I found for that field is 212099016004150509<br />
Give me sample code that does the conversion.<br />
<br />
Thanks<br />
bhaskar<br />

</div>
</div>


I have file with contents retrieved from mysql DB.
which has a time field with type defined bigint(20)
I want to parse that field into timestamp format(YYYY-MM-DD HH:MM:SS GMT) using python code.
The value I found for that field is 212099016004150509
Give me sample code that does the conversion.

Thanks
bhaskar


How to convert bigint(20) into timestamp format using python

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.