Wednesday, January 9, 2019

last date of year, first day of year, first friday of year, second friday of year in oracle sql

select add_months (trunc (sysdate, 'year'), 12) - 1 "last date of year"
from dual;

select trunc (sysdate, 'year') "first day of year" from dual;

select next_day (trunc (sysdate, 'year'), 'friday') "first friday of year"
from dual;


select next_day (next_day (trunc (sysdate, 'year'), 'friday'), 'friday')
"second friday of year"
from dual;

1 comment:

  1. � Also, Sethe may get access to your girlfriend forgotten about heritage by simply �telling� Treasured, with �distance belonging to the occurrences on their own, � reviews because of the girl's last, for the reason that Morrison contributes articles, �she was basically keeping in mind a thing the girl experienced neglected this lady knew� (Morrison 69, 73). https://imgur.com/a/qCb79qp https://imgur.com/a/r3rcSK4 https://imgur.com/a/97WyGF5 https://imgur.com/a/tt8VE2u https://imgur.com/a/mfAlVct https://imgur.com/a/wDgmQv3 https://imgur.com/a/Uo5D64d

    ReplyDelete

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...