A quick question. How do we find the difference in hours between 2 timestamps when the timestamps are in "YYYY-MM-DD HH:MM:SS" format? #TIMESTAMP
Please let me know if there are any ways to find it.
Thanks in advance!
the easiest way is cutting out the time and then using DIFF_TIME
I would also try out the SUB_TIMESTAMP() function which subtracts one timestamp from another. It might be able to give you what you want?