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

8 votes343 views1 answer
Alter tablespace add datafile
SQL
0 vote392 views1 answer
Psql check if sql script is valid
SQL
2 votes372 views1 answer
Removing view
SQL
3 votes345 views1 answer
Select table column in sql
SQL
2 votes348 views1 answer
Import large .sql files into lampp
SQL
0 vote357 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote338 views1 answer
Mysql select where text contains
SQL
2 votes342 views1 answer
Drop table if exists in postgres
SQL
4 votes367 views2 answers
Installing sql on ubuntu
SQL
1 vote343 views3 answers
Mysql disable foreign keys check
SQL