Sitemap

Amicuk Programming Answers

How to get first day of calendar week ?

2015-10-11   Views:1

Advertisement

hi, i'm storing some calendar weeks in my database. for example 30/2013. How can i get the first day of this week (monday)? in this case it is 22.07.2013 thx AnjaAs far as I know we don't have a function that converts week of a year into date. So you

hi,
i'm storing some calendar weeks in my database. for example 30/2013.
How can i get the first day of this week (monday)? in this case it is 22.07.2013
thx
Anja

The replay answer
Advertisement
As far as I know we don't have a function that converts week of a year into date. So you can try something like this.
SQL> with t
  2  as
  3  (
  4  select '30/2013' week_year
  5    from dual
  6  )
  7  select min(dt) week_start_day
  8    from (
  9           select (level - 1) + to_date('01-01-' || substr(week_year, -4), 'dd-mm-yyyy') dt
10                ,  week_year
11             from t
12          connect
13               by level <=  to_date('31-12-' || substr(week_year, -4), 'dd-mm-yyyy') -
14                            to_date('01-01-' || substr(week_year, -4), 'dd-mm-yyyy') +1
15         )
16   where to_number(to_char(dt, 'iw')) = to_number(substr(week_year, 1, instr(week_year, '/')-1));
WEEK_STAR
22-JUL-13

Go to See the other 10 answers

How can I see Calendar event END times at a glance?

Category:DefaultRelease time:2015-10-11Views:130

How can I display my Calendar event titles exactly as I type them? I do not want Calendar to remove duration from the titles of my events. Otherwise I can't see event END times at a glance in month view; only start times. How can I "trick" Calen[More]

Looking for Daily Calendar At-a-Glance App

Category:DefaultRelease time:2015-10-11Views:130

I'd love to find an app that will post an alert to my iPhone each morning listing out my day's calendar events. Anyone know of one? For what it's worth, I have 4 active calendars in Calendar app.I don't know of any apps like the one you want; however[More]

Can I show a color bar instead of a color bullet in iCal Monthly view for all my events in all calendars?

Category:DefaultRelease time:2015-10-11Views:130

In the Monthly view of iCal the only events that show a color bar in the event is the Birthday Calendar. All other events in all my other calendars only show a color bullet next to the event (unless I click on that event which then shows as a color b[More]

I create a birthday calendar in iCal and then click on it in iphoto at the begining of the calendar project each year.  Some how the birthday did not populate the photo calendar.  Is there a way to add the birthday iCal calendar into the calendar project?

Category:DefaultRelease time:2015-10-11Views:130

I created a birthday calendar to use in iphoto for calendar.  When a new calendar project is started each year, I click on it in.  Some how the birthday did not populate the photo calendar this year.  The photo calendar is almost complete.  Is there[More]

Cannot send email from iPhone5--calendar syncing issues also

Category:DefaultRelease time:2015-10-11Views:130

I have an iPhone 5 and am not currently using iCloud.  I have 3 email accounts.  The first is a yahoo email account--and it both receives & sends emails just fine.  I use Outlook for the other two email accounts (one is an IMAP and the other is a POP[More]

Get all calendars from root

Category:DefaultRelease time:2015-10-11Views:130

Hi guys, I am developing an integration with EWS based on php. I am using a library I found https://github.com/jamesiarmes/php-ews In my case users have various calendars hanging from the root, I get access to the default calendar by this: $request->[More]

Hi, I was trying to copy and paste a lot of  info for one day on my calendar to another day and an error message popped up saying that the system responded with an error. Msg won't go away I force quit ical

Category:DefaultRelease time:2015-10-11Views:130

Need help for trying to unfreeze a message on my ical.  I was trying to copy and paste some appointment info from one day to another on my ical and a message popped up saying the system responded with an error.  All of my info was below the message. [More]

How can I get ALL of my Google Calendars to show on the iCal on my iPhone? I see all of my Google Calendars on the iCal on my Mac, but I do not see them in the iCal on my iPhone. I only see one Google Cal, but not the others.

Category:DefaultRelease time:2015-10-11Views:130

How can I get ALL of my Google Calendars to show on the iCal on my iPhone? I see all of my Google Calendars on the iCal on my Mac, but I do not see them in the iCal on my iPhone. I only see one Google Cal, but not the others.https://www.google.com/ca[More]

I need help with Sunbird Calendar, how can I transfer it from one computer to the other and to my iphone?

Category:DefaultRelease time:2015-10-11Views:130

I installed Sunbird in one computer and my calendar has all my infos, events, and task that i would like to see on another computer that i just downloaded Sunbird into. Also, is it possible I can access Sunbird on my iphone? Thank you in advance,Try[More]

How do my partner and I share our calendars on our iPhones?

Category:DefaultRelease time:2015-10-11Views:130

Hello.  I am completely new to all of this so I apologise if I don't follow any protocols correctly.  I would love some help to figure out the best way for my partner and I to share our calendars on our iPhones please.  I have done a lot of research[More]

How can I have one calendar on one machine with 2 users

Category:DefaultRelease time:2015-10-11Views:130

I just replaced my macbook with a mac mini.  I created a second account, for my wife, on the machine.  Being 2 retired people, we don't need separate calenders. In fact, we often need to see what the other is doing.  So, what i'd like to do is have o[More]

Hot
Hi, we developed a PowerPivot Workbook and published on our PowerBI site based on a Sharepoint Online E3 subscription. We use it to display PowerView Dashboard and analyse sales results. On-prem we also have a Reporting Services (stand alone installa [More]
I have a 8GB iPod nano and I am not sure if it is blue tooth compatible.  How can I tell?According to this, an iPod nano has Bluetooth capability: http://store.apple.com/us/buy-ipod/ipod-nano BarryRead other 2 answers [More]
My apple mouse is not working.  I can get it to connect but it will not move the pointer.  Left and right click is working, scrolling, just cannot move the pointer.  Also, I have replaced the batteries (numerous times) but the green power light turns [More]
Hi all,     I want to enhance the extract structure to get KBETR & KBRUE fields of KONP table since it didn’t allow me to add those fields while creating the generic extractor because of currency key problems. I want to read all KONP records into int [More]
I had to take in my everyday iPhone 3G 16G to get it replaced under warranty. I backed it up before I took it in,and then tried to do a restore from backup to my spare iPhone 3G 8G. It will transfer all of the contacts, text messages, calendar, and s [More]
Hi! I have configured the Check Flight Seat demo and I can execute it without an error after a restart of the whole SAP system. When I would like to execute it again I get following error: 405 ICM_HTTP_INTERNAL_ERROR In message monitoring is a CLIENT [More]
I am trying to revoke a role in a DB level trigger. I am using 'execute imediate' to do this. I have also tried to do it the old fashioned DBMS_SQL.PARSE way. When the trigger fires I get this error: ORA-04092: cannot COMMIT in a trigger. I understan [More]
I'm trying to bring up a new computer and just installed CS3, which was an online upgrade to CS2. I'm getting the "Product License Had Expired" message, but I never had the beta installed (fix in Adobe Tech Note). In fact, this is only the secon [More]
Hi, I've been slowly working on a project from a holiday we took early 2009 (yep, I mean slowly). I was actually getting close to having the movie finished and ready for export but now iMovie won't even show the project and this is a long project The [More]
Dears, I have a PO Receipt got this entry Dr : Cost Variance Account Cr : Receiving Account without the Material Account Note:the Org Parameters is : Cost Method = Average and Negative Inventory Balance is unchecked Can any one explain to me why it g [More]