Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle convert hours to minutes

SELECT REGEXP_SUBSTR(ATT.workdur,'[^:]+',1,1)*60 + REGEXP_SUBSTR(ATT.workdur,'[^:]+',1,2) MINUTES FROM DUAL;
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL IN Operator With Subquery 
Sql :: sql join on wildcard 
Sql :: sql not exists 
Sql :: sql merge statement 
Sql :: Truncate a table then insert data 
Sql :: cast as decimal postgresql 
Sql :: sql max count 
Sql :: sql create database statement 
Sql :: denormalization in sql example 
Sql :: into operator in sql 
Sql :: mariadb cast null to 0 
Sql :: IntegrityError at duplicate key value violates unique constraint DETAIL: Key id already exists. 
Sql :: copy table db 
Sql :: insert data to postgresql from excel 
Sql :: postgresql between 
Sql :: sql is not like 
Sql :: sql order by clause 
Sql :: clustered-nonclustered indexes(constraints) 
Sql :: mysql comparing dates 
Sql :: synonym oracle 
Sql :: mysql null 
Sql :: mysql get auto_increment value 
Sql :: SQL MIN() Function 
Sql :: execution time of mysql query 
Sql :: limit rows after order by oracle 
Sql :: SQL SELECT-Klausel 
Sql :: query params sql insert python f string 
Sql :: exectuer myssql .sql 
Sql :: mysql create index lost connection 
Sql :: sql countif 
ADD CONTENT
Topic
Content
Source link
Name
2+4 =