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 vote97 views1 answer
Alter session set nls_language french
SQL
0 vote151 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote128 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote129 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
4 votes130 views1 answer
Oracle table statistics last analyzed
SQL
5 votes131 views1 answer
Sysdate in oracle sql
SQL
0 vote140 views1 answer
Get all employees if name ends with in sql
SQL
4 votes146 views1 answer
Mysql biginteger size
SQL
2 votes138 views1 answer
Change primary key sql
SQL
1 vote141 views3 answers
Mysql connection string
SQL