Turn Date Time

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Wed, 14 Nov 2007 10:14 am

Hi people!
I need a help! I don't know if this topic has already been dicutido, but it would be nice to have a \"Browse by SUBJECT\" in that forum. Just a tip! :D

So ... I need to do the subtraction of two dates (dd-mm-rrrr hh25: mi: ss) and transform the result in hours ... totally forgot how to do that .... lol ... could someone \"ilumiar\"??

Location: Santa Bárbaba d'Oeste

Poston Wed, 14 Nov 2007 10:33 am

Ju, all right?

Following, when searching, there is a link named \" Search \" here on the Forum (just after FAQ), which can also be accessed by the address: search.php on the issues of date, you can search for \"hours\" or \"dates\", you will find interesting links like these below, that can help her: viewtopic.php?t=1576&highlight=horas viewtopic.php?t=1008&highlight=datas [color = blue] Tip: [/color] If you want to know the difference in HOURS between two dates, do it like this:
Code: Select all
SELECT (TO_DATE('21/07/04 09:00', 'DD/MM/RR HH24:MI')
         -TO_DATE('20/07/04 18:00', 'DD/MM/RR HH24:MI')) *24 HORAS
qualquer thing, send it to us.
Location: Araraquara - SP


OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional

Poston Wed, 14 Nov 2007 10:41 am

OLHAAAA .... thank you!
The demand there.. I hadn't even seen ... thank you dinovu!

I will consult.

even more!
Location: Santa Bárbaba d'Oeste

  • See also
    Last Post