mercoledì 8 settembre 2010

LASTDAY FUNCTION

Oracle db gives us a function to determine last of a month.
Using sintax similar as follows :

SELECT LAST_DAY(TO_DATE('20100908','YYYYMMDD')) FROM dual;

This is the output



Nessun commento:

Posta un commento