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 installed BI 10.1.3.2.0 successfully. I tested my convert servlet (which comes with BI Publisher) by trying to go there directly in browser: http://roman:80/xmlpserver/convert I get the message in Firefox: "500 Internal Server Error Servlet error: [More]
Is it possible to share my iPhoto library (Yosemite) with my wife's iPad? She doesn't have a separate mac, but she does have her own apple ID.No You can share selected photos using PhotoStream - you can not share the library Next year the Photos App [More]
Hi, I am using NI LabVIEW, NI PXI 4071, and NI PXI 6070E to measure current through a variable resistance. Now, I am using one channel from SCB-68, but I want to add another channel in parallel so that I can have two resistors instead of one that I c [More]
Upgrading from 10.4.7 have fixed many of my problems. Certain apps take up more cpu power and ram i assume. It will freeze almost within 10 minutes of use. If i dont manually restart by holding the power button down. Within 2-5 minutes the black scre [More]
All of a sudden my LaserJet P1102w gets stuck printing PDFs from Preview.  The computer is on OS 10.10.1.   The printer worked normally after I installed Yosemite some months ago.  Then yesterday, out of the blue, after printing two PDFs in Preview, [More]
Dear Friends, I have one internal table with parent and child, again child will be acting as parent and it can have further childs ...... like that it goes on there is no constant levels it goes on.... for example. parent child 100 101 102 103 101 20 [More]
Using BES, Curve 8330 on 4.5 and Outlook 2003 Exchange... Any time I enter an address in my Curve, it will sync perfectly with Exchange and sync with my outlook contacts. However, every time, it will sort by last name, first name. I've told the BB de [More]
Hi friends! I bought a LG FLATRON LCD DISPLAY Model M1994A. My Macbook 13" have a 10.5.6 Leopard. The fact is when connect de Macbook with LCD screen thru VGA cable and miniDVI adapter. Plug the miniDVI adapter, and the screen of Macbook blinking for [More]
Hi, I am new to UNIX admin, i am going to write a script in such a way that it has to send a mail to root if any errors in /var/adm/messages file. Can any one please send useful links or sample script file? Thanks Rameshhttp://www.sunfreeware.com/ind [More]
My iphoto-library runs on an external HDD (using a MBP 256 SSD). It contains 38.000 photos, lots of albums and projects (photo albums) and a week ago it crashed. I accidentally removed the hdd while using iphoto. This happened to me before and with a [More]