mysql - How to extract hour from timestamp?

Question

I have taken only the time value from systimestamp. But with the same i need to extract hour from time value.

SELECT EXTRACT (HOUR FROM TO_CHAR(systimestamp,'hh24:mi:ss'')) FROM DUAL ;

but I'm getting "invalid extract field for extract source"

question from:https://stackoverflow.com/questions/66050753/how-to-extract-hour-from-timestamp

Answer 1

You can also use to_char as follows:

SELECT to_char(systimestamp,'hh24') FROM DUAL