News for hackers. Stuff that matters.
Re:64-bit unix timestamp is not supported in MySQL functions... by PhasmaFelis on Tuesday December 10, 2019 @09:54PM (#21759151)
Whoever set up the database for my current work project apparently thought that wasn't enough, because it's got a whole lot of columns called "dateTimeStamp" which--on inspection--turn out to be VARCHARs containing a string representation of a timestamp. In ISO 8601 format. The one that looks like "2019-12-11T00:04:37.754329Z".

Yes, they actually have six decimal digits of precision. For tracking boxes on a warehouse conveyor belt.

Re:64-bit unix timestamp is not supported in MySQL functions... by blattimwind on Tuesday December 10, 2019 @10:14PM (#21759234)
First time I've seen someone complain about finding standard ISO 8601 in a database.
Re:64-bit unix timestamp is not supported in MySQL functions... by PhasmaFelis on Tuesday December 10, 2019 @11:36PM (#21759632)
This particular database is mainly used to display results to humans, and whoever wrote the original code didn't bother to convert it from 8601 to human-readable (one of the things I'm fixing), so it stands out.
Re:64-bit unix timestamp is not supported in MySQL functions... by mjbmitch on Tuesday December 10, 2019 @10:12PM (#21759224)
The precision is likely the default of whatever instrument recorded the timestamps. At this point, however, having to use VARCHARs instead of some native representation of ISO 8601 is entirely the fault of Oracle. It has been a published standard for over 30 years and should be directly supported.
Re:64-bit unix timestamp is not supported in MySQL functions... by PhasmaFelis on Tuesday December 10, 2019 @11:41PM (#21759653)
> At this point, however, having to use VARCHARs instead of some native representation of ISO 8601 is entirely the fault of Oracle.

I wish I could blame Oracle. We're using Watcom SQL on a Sybase DB.

Re:64-bit unix timestamp is not supported in MySQL functions... by selimthegrim on Tuesday December 10, 2019 @10:00PM (#21759175)
Maybe they worked for NATO in a previous job?