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
I have the dreaded broken Mail x64 Control Panel that doesn't work after installing Office 2013 Home and Business on a Windows 8.1 Pro computer.  This was a fresh installation, yet Microsoft still has an ancient disk image on their Office.com website [More]
I'm not sure how many Verizon employees use these forums or if any consumers know of any solutions to my problem but I figured I'd give this a try. I recently purchased a Samsung theater consisting of the LED UN46B600, BluRay BD-P1600 and SoundBar HT [More]
I tried to pay my bill online using the Verizon gift card that I received when I signed up for Verizon Fios. It would not let me do it. I got an error message that my payment transaction failed because of an invalid card or authorization is decline b [More]
I've upgraded from PSE6 to PSE9. PSE9 reported no failures when converting my PSE6 catalog. When I open the organizer, all looks fine. If I go to full screen on a photo, then click play to run a slide show, the organizer works fine for a while, then [More]
Lightroom starts up fine when I insert a CF card, but it only ever imports the jpg files , never the ARW ones. ARW is the extension for the RAW files of the Sony Alpha 100 camera.There is no problem with importing ARW files if i search for them & man [More]
Hi, When setting up an architecture where servers should be accessible only to a subset of the platform's users, e.g. geographically dispersed installations, SAP has always said to use server groups and assign the content (i.e. the reports) to the co [More]
Hello Gurus, When I set up an interaction with action link, every thing works fine. But when I try to use the 'show link conditionally' using a simple condition, I get an error such as: "State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSErro [More]
Hi all! Today I match an error and still can not resolve, I need you help me to correct it When I change server name (old is dipasrv to domsrv) the OC4J_PORTAL can not start and when access portal page the following error appear. If you know, plz hel [More]
Hi Gurus, We are busy installing SAP NetWeaver 7.0 (2004s) SR2  (ABAP+JAVA) with an Oracle 10.2 DB. We get the following error during the installation. WARNING 2008-09-12 08:02:52.947 Execution of the command "C:\j2sdk1.4.2_18-x64\bin\java.exe -Xmx64 [More]
Is it possible to run a Photoshop script line by line ? I'm want to debug a script and it would be helpful.ExtendScript Toolkit contains an editor/debugger. It's an optional download somewhere on adobe.com.Read other 4 answers [More]