tag:blogger.com,1999:blog-695984655367698186.post241064662585345930..comments2023-08-02T16:37:06.853+02:00Comments on HR Access ... and Me: Afficher une différence de dates en "heures minutes secondes" avec DAY TO SECOND (Oracle)DiGixhttp://www.blogger.com/profile/03595785699258792074noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-695984655367698186.post-70291437726440517872013-06-28T10:39:39.851+02:002013-06-28T10:39:39.851+02:00Certaines rubriques n'existent pas en V5
ça pa...Certaines rubriques n'existent pas en V5<br />ça passe comme ça <br /><br />SELECT CDPHAS,CDELMT,TIMDEB,TIMFIN,CDRET,SUBSTR(((TIMFIN - TIMDEB) DAY TO SECOND(0) ),1,12) AS DELTA, LIUTIL FROM ZO00,ZO2C WHERE ZO00.NUDOSS=ZO2C.NUDOSS AND CDRET <> ' ' AND TIMFIN > TRUNC(SYSDATE) ORDER BY TIMFIN ASC ;<br />Anonymousnoreply@blogger.com