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

0 vote360 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote356 views1 answer
Sql pivot table
SQL
0 vote353 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote347 views1 answer
Round function in sql oracle
SQL
9 votes365 views3 answers
Find all tables with column name
SQL
1 vote341 views1 answer
Oracle select first result
SQL
0 vote397 views1 answer
Delete ids between sql
SQL
2 votes329 views2 answers
How to DROP a table in mysql
SQL
1 vote318 views1 answer
Show table columns
SQL
3 votes428 views1 answer
Oracle cannot access v$session
SQL