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

3 votes286 views1 answer
Postgres count distinct
SQL
0 vote266 views1 answer
Soql user profile
SQL
0 vote267 views1 answer
UNION ALL LEFT JOIN
SQL
11 votes253 views2 answers
Import sql file laravel cmd
SQL
0 vote255 views1 answer
Comma seperated join mssql
SQL
0 vote264 views1 answer
Get null value in sql
SQL
0 vote266 views1 answer
Postgres statistics
SQL
0 vote264 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote237 views1 answer
Python escape string for sql
SQL
0 vote276 views1 answer
Java mysql swing example
SQL