Oracle extract minute from date

SELECT EXTRACT(HOUR FROM SYSTIMESTAMP) AS c_hour FROM DUAL; 
SELECT EXTRACT(MINUTE FROM SYSTIMESTAMP) AS c_minute FROM DUAL; 

SELECT to_char(sysdate, 'HH24') FROM DUAL;
SELECT to_char(sysdate, 'MI')  FROM DUAL;

Similar codes

4 votes136 views1 answer
What are the data types in sql
SQL
0 vote140 views2 answers
Nosqlbooster query other collection
SQL
0 vote135 views1 answer
Initcap in sql
SQL
5 votes138 views1 answer
How to get all dates in a month in oracle
SQL
0 vote135 views1 answer
Nth max in my sql
SQL
0 vote166 views1 answer
Postgresql select fast check no rows
SQL
0 vote147 views1 answer
Default value false mysql
SQL
0 vote146 views1 answer
Get role postgres
SQL
5 votes148 views3 answers
Truncate function in sql oracle
SQL
3 votes139 views4 answers
Mysql decimal
SQL