OraFAQ Forum: Forms » Fortnightly off required

Home » Developer & Programmer » Forms » Fortnightly off required (Oracle Query)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fortnightly off required [message #674065]

Tue, 01 January 2019 04:26

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.

Report message to a moderator

Re: Fortnightly off required [message #674067 is a reply to message #674065]

Tue, 01 January 2019 05:04

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

What SQL have you tried so far? Where are you stuck?

Report message to a moderator

Re: Fortnightly off required [message #674068 is a reply to message #674067]

Tue, 01 January 2019 05:12

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')

Report message to a moderator

Re: Fortnightly off required [message #674069 is a reply to message #674068]

Tue, 01 January 2019 14:17

John Watson
Messages: 8963
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.

Report message to a moderator

Re: Fortnightly off required [message #674070 is a reply to message #674068]

Tue, 01 January 2019 14:47

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 07:55:31 CST 2025