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
For some reason, the scanner will not work.   Initially when I click on Autoscan on the PC menu  the message reads that the scanner is warming up.  Then I get an Error Message:  Internal Error Occurred Scanner Driver Will be Closed.  I don' t know wh [More]
I have a table arm. In that loan_number,change_begin_date and change_end_date are composite primary key.so i want only one data for loan_number as per this condition change_begin_date <= trunc(sysdate, 'mm')-1 and change_end_date >= trunc(sysdate, ' [More]
Hi all:     I would like to setup JDI track for enhance ESS/MSS in ep7.     I create a new track in CMS named as ESSD2 ( did not create product in sld )     I check in SAP_BUILDT , SAP_JTECHS, SAP-JEE into the CMS and I found there is 49 dcs in CBS - [More]
in the first itunes i had the option show dubbel parts but whit the newer one i cant find that option annymore, where is it?palkia wrote: in last 4 days, i been using the new ip4 to take important photos and creating new contact.my new ip4 never snyc [More]
Hi I need help with verticle spry menu bar drop down menu. When I test locally it's working fine but when I upload the drop down menu isn't working I've spent days to fix it but couldn't can anyone help me it's driving mad!!!!! Thanks.Hi Ken, I hope [More]
I am trying to run a course from an LMS (Coursemill) and a couple issues are occurring. First, the quicktime plugin crashes, therefore the mp3 sound of the course does not play. When I reload the page, I get an "Unable to find API adapter" error [More]
I'm relativly new to the OWB but I'm in the learing proces...I have some serious problems mapping the cube. How do I map my surrogate dimension key into the cube (which has the same surrogate key)? Do I have to map them at all or are they automatical [More]
Hello, I want convert this VI in 10.0 to 8.2.  (My labVIEW is in 8.2) Thank you. Attachments: Recup signal (projet final)_state_machine.vi ‏312 KBLV8.2 Attachments: RecupSignal(projectFfinal)_state_machine[1].vi ‏309 KBRead other 2 answers [More]
Hi! I'm a ower of a bluetooth headphones / headset, Bose AE2w. I can not pair with the headphones. I'm using blueman-manager to pair. The headphones are detected but not connected. The message is: "Device Added successfuly, but failed to connect" [More]
HI- half the time I export a jpg from iphoto and email it ( using the mail program) to my sister she can never open them. sometime she can though abd I am always exporting them the same way! so strange. any ideas on why this might happen or the best [More]