I have a table where I have 2 fields that represent unix epoch timestamp hex example "62508501", "624F645F". They are strings data type. I want to be able to compare the 2 timestamps.
Can I straight up compare these string:
ts1_hex_string > ts1_hex_string
- Would this be an accurate representation of comparing the actual data/time timestamps?
- If not, what is the easiest way to compare in SQL or python?