الصفحات
Home
Arafa
Contact me
Oracle SQL
Oracle PL/SQL
LINUX
1/10/2013
How to get first SATURDAY after six months
السلام عليكم
من خلال الكود التالى سوف تحصل على اول سبت بعد سته اشهر
Code
SELECT
NEXT_DAY(ADD_MONTHS(TRUNC(SYSDATE,'YEAR'),6),'SAT')
FROM DUAL;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment