I am trying to create a report based on some tables our software is populating. It has a CreateDate column, which logs when the row was inserted to the table. The CreateDate column is of BigInt type, and not datetime.I was wondering if maybe this was a common thing to do? Or are the intentionally making it hard to decipher? Here are some sample rows, all were entered within about 4 seconds from start to finish128424607264976018128424607265132354128424607265132355128424607265132356128424607265132357128424607265288691128424607265288692128424607265445028128424607271229497128424607271385834128424607297025102128424607297494113128424607297806787128424607297963124128424607298432135128424607298744809128424607299213820128424607299995505128424607302027886128424607302184223128424607302184224128424607302340560128424607318286934128424607319224956128424607320319315128424607321882685128424607322039022128424607322039023128424607322195359128424607339548766128424607339548767128424607382854115128424607383010452128424607383479463128424607388794921128424607388951258128424607394892064128424607395048401128424607404897632128424607405053969128424607405210306128424607410994775128424607411151112128424607411151113128424607415997559128424607428035508128424607449297340128424607449453677128424607449453678128424607449453679128424607455394483128424607460397267128424607460397268128424607460397269128424607460397270128424607460553604128424607460553605128424607460553606128424607460709941128424607460709942128424607460709943128424607472435216128424607472435217128424607515740565128424607515740566128424607613451190128424607613451191128424607624394780128424607678956393
To compare with, here are some rows from yesterday - Based on the context of the software, I'm guessing these entries were also within a few seconds.128424533906808217128424533906808218128424533906964474128424533906964475128424533906964476128424533907120732128424533907120733128424533907276990128424533907276991128424533907276992128424533907276993128424533907433248128424533907433249128424533907433250128424533907433251128424533907589506128424533907589507128424533907589508128424533916808728128424533916808729128424533916808730128424533916808731128424533916964986128424533916964987128424533916964988128424533916964989128424533917121244128424533917121245128424533917121246128424533917121247128424533917277502128424533917277503128424533933215818128424534051971898128424534169634172128424534288233994128424534418084392
Here is one row from the first block of code (128424607678956393) vs. one from yesterday (128424534418084392).. Here is one from the day before yesterday (128424420012332500).So the bolded numbers have incremented by one for the past week, one each day. And the first 5 digits haven't changed. I can't seem to pin anything else down. Looking to see if anyone has seen date storage in this way before, and how to read it?I've searched the software's small community forums, and there are no discussions even mentioning the SQL Tables. I've made a post there as well.
Odd date storage - BigInt
Posted - 2007-12-18 : 10:02:42
