Re:HTTP GZIP Compression remote date and time leak
by rtkwe on Monday February 22, 2016 @04:01PM
(#11154249)
While that works it'd be a real annoyance to deal with when doing a lot of the debugging queries I wind up writing for work doing batch ETL. As far as I have found there's no built in function that would take that epoch timestamp and convert it into a usable date that could then be truncated for daily binning etc.
In a SQL database a time field should be an unsigned bigint.