Home » Developer & Programmer » Forms » Fortnightly off required (Oracle Query)
Fortnightly off required [message #674065] Tue, 01 January 2019 04:26 Go to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

I need fortnightly off of all of the year like my fortnighlyoff day is 01-jan-2019 next will be 15-jan-2019 and next will be 30-jan-2019
all dates is in my dummy table.
Re: Fortnightly off required [message #674067 is a reply to message #674065] Tue, 01 January 2019 05:04 Go to previous messageGo to next message
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
What SQL have you tried so far? Where are you stuck?
Re: Fortnightly off required [message #674068 is a reply to message #674067] Tue, 01 January 2019 05:12 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

I AM USING ORACLE

SELECT TO_CHAR(D.DAY_DATE, 'DAY') DAYS, D.DAY_DATE
FROM HRD.DUMMY_DAYS D
WHERE TO_CHAR(D.DAY_DATE, 'DAY') = TO_CHAR(SYSDATE, 'DAY')
Re: Fortnightly off required [message #674069 is a reply to message #674068] Tue, 01 January 2019 14:17 Go to previous messageGo to next message
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
Oh my gosh. Please do not use UPPER CASE like that: it is painful on the eyes.

I have no idea how the contents of your table and the query you have given are meant to generate 01-jan-2019, 15-jan-2019, and 30-jan-2019. There does not seem to be any relationship between those dates. And none to your query. You have to explain your problem again.
Re: Fortnightly off required [message #674070 is a reply to message #674068] Tue, 01 January 2019 14:47 Go to previous message
Michel Cadot
Messages: 66776
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You also have to post the solutions you found in your previous topics as we asked.
Why should we help someone who refuses to help others?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Previous Topic: Changing Database column dynamically in Oracle Forms
Next Topic: Not able to clear dependent lov (merged 7)
Goto Forum:
  


Current Time: Sun Jan 19 12:52:43 CST 2020