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
Code Example |
---|
:: drop table in mysql |
:: power query concatenate |
Sql :: |
:: |
:: delete all table oracle |
Sql :: |
Sql :: |
:: |
:: postgresql where datetrunc month and year equal |
Sql :: |
:: describe table query in postgresql |
:: sql to char |
:: |
:: |
:: |
:: |
:: |
:: |
Sql :: |
:: |
Sql :: |
:: |
Sql :: |
:: |
:: can you update NULL in sql |
:: |
:: |
:: |
:: |
:: |