Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to convert number to hours and minutes in oracle sql

WITH c AS (SELECT 492 AS MINUTES FROM DUAL)
SELECT trim(to_char(trunc(MINUTES / 60), '09')) || ':' ||
       trim(to_char(trunc(mod(abs(MINUTES), 60)), '09')) AS HHMM
FROM c;																-- 08:12
Comment
PREVIOUS NEXT
Code Example
Sql :: oracle list invalid password ORA-01017 
Sql :: sql change table name 
Sql :: metasploit start postgresql 
Sql :: current setting postgres timezone 
Sql :: generate random data postgresql 
Sql :: set statiscis on in sql server 
Sql :: get month of date sql 
Sql :: create table mysql query 
Sql :: mysql return text after a final full stop 
Sql :: oracle current timestamp 
Sql :: wordpress sql change site url 
Sql :: postgresql show current database 
Sql :: oracle get trigger ddl 
Sql :: set permanent SET GLOBAL sql_mode ubuntu 
Sql :: sql query with replace function 
Sql :: How to disable foreign key checks ? 
Sql :: psql show with user is logged in 
Sql :: mysql cli connect with password 
Sql :: prosys sql log 
Sql :: how do you use sql in you company 
Sql :: default password of mysql 
Sql :: get all table names in sql 
Sql :: sql update alias 
Sql :: column names in oracle sql 
Sql :: postgres format date in select 
Sql :: oracle add column with default value 
Sql :: postgres count string length 
Sql :: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed 
Sql :: select columns table mysql 
Sql :: hangfire clear all jobs 
ADD CONTENT
Topic
Content
Source link
Name
1+2 =