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

2 votes225 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote277 views1 answer
Postgresql print variable
SQL
0 vote204 views1 answer
Select other columns with distinct
SQL
0 vote231 views1 answer
Sql select lowest value row
SQL
0 vote216 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote257 views2 answers
Difference between in and between in sql
SQL
0 vote206 views1 answer
Postgresql update to unique
SQL
4 votes199 views1 answer
To date oracle with time
SQL
1 vote221 views1 answer
Lpad function in sql oracle
SQL
0 vote199 views1 answer
Postgres read table structure
SQL