Search
 
SCRIPT & CODE EXAMPLE
 

SQL

différence entre deux dates sql oracle

 SQL> select 24 * (to_date('2009-07-07 22:00', 'YYYY-MM-DD hh24:mi') - to_date('2009-07-07 19:30', 'YYYY-MM-DD hh24:mi')) diff_hours from dual; DIFF_HOURS ---------- 2.5
Comment
PREVIOUS NEXT
Code Example
Sql :: how to delete table in mysql 
Sql :: drop table in mysql 
Sql :: add postgresql to path 
Sql :: nvl2 syntax 
Sql :: sql query inline if 
Sql :: clear screen command in psql 
Sql :: sql insert query 
Sql :: sql replace null with 0 
Sql :: import .sql into postgres db command 
Sql :: Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux 
Sql :: sql query to find duplicate email address 
Sql :: strict in postgres SQL 
Sql :: mysql root localhost run 
Sql :: create mysql user 
Sql :: how to delete git repo locally 
Sql :: oracle asynchronous update 
Sql :: wsl centos 8 mysql 
Sql :: show processlist mysql full query 
Sql :: create table like sql 
Sql :: how to change the value of a table in sql 
Sql :: mysql error incompatible with sql_mode=only_full_group_by 
Sql :: a network or instance-specific error sql server 
Sql :: sql delete join 
Sql :: mysql limit offset 
Sql :: oracle auto_increment 
Sql :: postgresql left join distinct on 
Sql :: postgres change column type to uuid 
Sql :: delete top N rows in sql 
Sql :: temp table sql 
Sql :: mysql set value as null 
ADD CONTENT
Topic
Content
Source link
Name
4+8 =