all-IT

If you set the program to a backend (ie database), we can let the program already there to do some tasks.

A good example of how the calculation date. As in Java, a "seizure" is can be very easy for Oracle in the database query (using SQL) do.

If you want to, for example, the time difference between now and the end of the month would be determined, the following possible solution:

 , LAST_DAY ( SYSDATE ) "Monatsende" , LAST_DAY ( SYSDATE ) - SYSDATE "Tage bis zum Monatsende" FROM DUAL;   heute Monatsen Tage bis zum Monatsende -------- -------- ----------------------- 29 . 09 . 09 30 . 09 . 09 1 SELECT SYSDATE "today", LAST_DAY (SYSDATE) "Month End", LAST_DAY (SYSDATE) - SYSDATE "days until the end of the month 'FROM DUAL; --------------- today Monatsen days until the end of the month ------------------------ 29th 09th 09 30th 09th 09 1 

The only drawback is the SQL function last_day not in any database system.

If you set the program to a backend (ie database), we can let the program already there to do some tasks. A good example of how the calculation date. As in Java, a "seizure" is can be very easy for Oracle in the database query (using SQL) do. If you want to, for example, the time difference between now and the end of the month to determine would be the following approach is possible: SELECT SYSDATE "today", LAST_DAY (SYSDATE) "Month End", LAST_DAY (SYSDATE) - SYSDATE "days until the end of the month 'FROM DUAL; today Monatsen days end of the month 29.09.09 30.09.09 1 --------------------------------------- The only disadvantage is the SQL function last_day not in any database system.

gklinkmann written by \ \ tags: Oracle