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

12 votes199 views6 answers
Select distinct
SQL
0 vote195 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote224 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote223 views1 answer
Sqlite version check
SQL
0 vote214 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote196 views1 answer
Firebird where
SQL
13 votes188 views2 answers
Display users in mysql
SQL
3 votes246 views1 answer
Oracle nextval insert
SQL
5 votes206 views1 answer
Sql use database
SQL
-1 vote186 views3 answers
Check table exist postgresql
SQL