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 vote193 views2 answers
Sql drop view if exists
SQL
15 votes195 views4 answers
Sql update from select
SQL
0 vote180 views2 answers
Sql query unique
SQL
0 vote186 views2 answers
Mysql regexp match word
SQL
1 vote191 views2 answers
Sql select only first occurrence
SQL
0 vote156 views1 answer
Create duplicate table in postgresql
SQL
0 vote183 views1 answer
Renommer schema sql
SQL
17 votes204 views6 answers
MySQL ORDER BY
SQL
0 vote194 views1 answer
How to query all tables mysql at the same time
SQL
1 vote204 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL