blog.joachim-selke.de

Joachim Selke’s Blog

How to Convert ISO Weeks to Dates in Oracle. Converting a date to an ISO year-week string is easy in Oracle:. SELECT TO CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10. One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should also be easy:. So, obviously this is not supported yet (speaking of version 11g R2). Therefore, I decided to write a conversion function myself. Here it is:. For those prefering plain SQL:. TRUNC(., 'D'). As there doe...

http://blog.joachim-selke.de/

OVERVIEW OF blog.joachim-selke.de

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR BLOG.JOACHIM-SELKE.DE

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

September

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 13 reviews

5 star

5

4 star

5

3 star

2

2 star

0

1 star

1

Hey there! Start your review of blog.joachim-selke.de

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

CONTACTS AT BLOG.JOACHIM-SELKE.DE

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

18

SSL

EXTERNAL LINKS

5

SITE IP

134.119.45.77

LOAD TIME

0 sec

SCORE

6.2

PAGE TITLE

Joachim Selke’s Blog | blog.joachim-selke.de Reviews

<META> DESCRIPTION

How to Convert ISO Weeks to Dates in Oracle. Converting a date to an ISO year-week string is easy in Oracle:. SELECT TO CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10. One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should also be easy:. So, obviously this is not supported yet (speaking of version 11g R2). Therefore, I decided to write a conversion function myself. Here it is:. For those prefering plain SQL:. TRUNC(., 'D'). As there doe...

<META> KEYWORDS

1 joachim selke’s blog

2 skip to content

3 larr;

4 older posts

5 posted on

6 joachim selke

7 a quick test

8 another one

9 perfect

10 have fun

CONTENT

Page content here

KEYWORDS ON PAGE

joachim selke’s blog,skip to content,larr;,older posts,posted on,joachim selke,a quick test,another one,perfect,have fun,update,changed,posted in,oracle,18 comments,note,util,example xsl,inputxml,content,the output,test xyz test,5 comments,2 comments,nice

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Joachim Selke’s Blog | blog.joachim-selke.de Reviews

https://blog.joachim-selke.de

How to Convert ISO Weeks to Dates in Oracle. Converting a date to an ISO year-week string is easy in Oracle:. SELECT TO CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10. One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should also be easy:. So, obviously this is not supported yet (speaking of version 11g R2). Therefore, I decided to write a conversion function myself. Here it is:. For those prefering plain SQL:. TRUNC(., 'D'). As there doe...

INTERNAL PAGES

blog.joachim-selke.de

1

Joachim Selke’s Blog | Page 2

http://blog.joachim-selke.de/page/2

Newer posts →. How to move a table to a different tablespace in DB2. Recently I had to move a table of some DB2 database to a different tablespace (building an index required a larger page size). At first, I suspected changing tablespaces to be one of those complicated operations that essentially require you to re-create the whole table. However, I was surprised to see that there is a simple admin procedure in DB2 for doing what I wanted (see ADMIN MOVE TABLE. For example, to move the table. 039;, '.

2

XML | Joachim Selke’s Blog

http://blog.joachim-selke.de/category/xml

Stripping (HTML) tags in XSLT. As there doesn’t seem to be any built-in function in XLST for stripping tags from strings (e.g., to remove all markup from a piece of HTML-formatted text), people came up with a recursive template-based solution, which has been posted several … Continue reading →. Proudly powered by WordPress.

3

How to Convert ISO Weeks to Dates in Oracle | Joachim Selke’s Blog

http://blog.joachim-selke.de/2012/03/how-to-convert-iso-weeks-to-dates-in-oracle

Stripping (HTML) tags in XSLT. How to Convert ISO Weeks to Dates in Oracle. Converting a date to an ISO year-week string is easy in Oracle:. SELECT TO CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10. One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should also be easy:. So, obviously this is not supported yet (speaking of version 11g R2). Therefore, I decided to write a conversion function myself. Here it is:. TRUNC(., 'D'). 8220;PL/SQL: ...

4

What SQL statements are currently running on my DB2 database server? | Joachim Selke’s Blog

http://blog.joachim-selke.de/2010/01/what-sql-statements-are-currently-running-on-my-db2-database-server

How to move a table to a different tablespace in DB2. How to look up SQL error codes quickly in DB2 →. What SQL statements are currently running on my DB2 database server? To see some detailed info about which users are currently connected to your DB2 database server (including the SQL statements they are running), you can use the following query (tested with DB2 9.7, fixpack 3a):. This entry was posted in DB2. How to move a table to a different tablespace in DB2. Excellent query… Thanks.

5

Stripping (HTML) tags in XSLT | Joachim Selke’s Blog

http://blog.joachim-selke.de/2011/01/stripping-html-tags-in-xslt

Where to Download the DB2 JDBC driver. How to Convert ISO Weeks to Dates in Oracle →. Stripping (HTML) tags in XSLT. As there doesn’t seem to be any built-in function in XLST for stripping tags from strings (e.g., to remove all markup from a piece of HTML-formatted text), people came up with a recursive template-based solution, which has been posted several times on the web (e.g., here. Don’t forget to declare a namespace for this function (called. In the above code). Xsl:stylesheet version=2.0 xmlns...

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL PAGES IN THIS WEBSITE

18

OTHER SITES

blog.joaa.se

Jo Åse - bilder & betraktninger

Jo Åse - bilder and betraktninger. Velkommen. Dette er bloggen til Jo Åse. Her legger jeg ut #fotografier. Og interessante ting fra det store internettet. Kontakt: jo.aase (krøllalfa) gmail.com. Walking in the forests of Stenshovuds National Park in Skåne. Nimis, huge sculpture by Lars Wilks. Althea and Aria at Vigelandsparken. Noen ganger trenger man bare litt ekstra motivasjon til treningen. Lillebror ser ut over vannet på Garntangen. Noen tanker om psevdonymitet. Grunnene en har til å ikke ville...

blog.joabhomearts.com

Oil Paintings 世界名画系列

发布于 2014-8-7 17:31 Thursday 分类世界名画. 首先要知道的几点忌讳墙面装饰挂线尽量统一色调，否则挂绳花花绿绿，破坏了艺术品本身的美感;客厅墙面是家庭装修的重地，切忌挂放年历、挂放印刷品以及根本搞不清有多少张数的名画复制品. 发布于 2014-6-18 22:51 Wednesday 分类世界名画. 也曾找过几份工作，但我不喜欢流水线的工作小珍说，时至今日，她依旧怀揣艺术梦想，终究没能放下身段去接受现实。发布于 2014-6-12 18:47 Thursday 分类世界名画. 发布于 2014-6-10 0:02 Tuesday 分类世界名画. Oil Painting Reproductions Museum Quality. 发布于 2014-5-8 0:27 Thursday 分类 Industry news. Oil Painting Reproductions Museum Quality. Our business philosophy is: to build Oil Painting Reproductions Museum Quality.

blog.joachim-burger.de

Joachim Burger - "Um klar zu sehen, genügt oft ein Wechsel der Blickrichtung."

Um klar zu sehen, genügt oft ein Wechsel der Blickrichtung. Alles neu macht der Juni…. Alles neu macht der Juni…. Designed by Joachim Burger.

blog.joachim-lehmann.com

Click here for recent photos. lehmann.photos. // Thank You

Click here for recent photos. lehmann.photos. 32; Latest. 32; Archives. 32; About. All images 2003-2014 Joachim Lehmann. Thank You 2014-12-13 10:51:44. Photoblog is closed. Please explore my recent photos on lehmann.photos. Please comment only picture. Other comments will not be published. Och, das ist aber sehr Schade! Frank @ 2014-12-15 12:44:00.

blog.joachim-schuett.de

JoS.BLOG ::Blog von Jo:: ein unfähiges Schießsportprogramm ::

10 Tag 24.01. 9 Tag 23.01. 8 Tag 22.01. 7 Tag 31.12. 6 Tag 01.12. 5 Tag 28.11. 4 Tag 27.11. 3 Tag 26.11. 2 Tag 25.11. 1 Tag 24.11. Bei dem Sportschützen Jo. Wer hier PDF-Dateien sucht, ist auf dieser Seite falsch. Hier gibt es nur „reines“ Internet und kein dilletantisches PDF-Gestammel wie auf manchen andern Home. Berichte und Stellungnahme über ein neues Schießsportprogramm im NDSB. Unsinn einer Monströsen EDV-Sportverwaltung die ich nicht brauche. Dabei ist 1 Gewehr! Insgesamt waren schon 7515 vor dir...

blog.joachim-selke.de

Joachim Selke’s Blog

How to Convert ISO Weeks to Dates in Oracle. Converting a date to an ISO year-week string is easy in Oracle:. SELECT TO CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10. One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should also be easy:. So, obviously this is not supported yet (speaking of version 11g R2). Therefore, I decided to write a conversion function myself. Here it is:. For those prefering plain SQL:. TRUNC(., 'D'). As there doe...

blog.joachim.at

development adventures

Joachim kerschbaumer about dot and net. 3April.09 – 12:27. When i was working with WPF earlier this morning i wondered how microsoft got to the color names in their System.Windows.Media.Colors. At least i’m somewhat confused that Gray ( #FF808080. Than DarkGray ( #FFA9A9A9. They probably have some really strange monitor settings over there in redmond. Using the new WPF Ribbon with CompositeWPF. 13November.08 – 18:45. R:Ribbon cal:RegionManager.RegionName="ApplicationRibbon" . /r:Ribbon. Public class Ribb...

blog.joachimbaur.de

Joachim Baurs Blog

Modellbau Georg Baur GmbH. COMBIN3: Our redesigned App is in BETA! A couple of months have passed since my last blog post, where I wrote about the planned reorientation of our COMBIN3-App. Although I could not work continuously on the redesign and coding of the app in that time, we reached an important milestone this week: the COMBIN3-App is now in beta! So I thought that’s […]. Veröffentlicht in COMBIN3. Keine Kommentare ». COMBIN3: Unsere neu gestaltete App ist in der Beta-Phase! 1 Kommentar ». This is...

blog.joachimblochphotos.de

PEOPLEFOTOGRAF JOACHIM BLOCH l Blog

PEOPLEFOTOGRAF JOACHIM BLOCH l Blog. Http:/ blog.joachimblochphotos.de/.

blog.joachimhummel.de

Joachim´s Blog – Aus dem Leben gegriffen

Aus dem Leben gegriffen. Unixweb – internet solutions. Sunlight Project feat. Anthya – Winter Of Love – Starchaser Mix. Juni 28, 2016. Schreibe einen Kommentar zu Sunlight Project feat. Anthya – Winter Of Love – Starchaser Mix. ATB – Careless. Mai 23, 2016. Schreibe einen Kommentar zu ATB – Careless. Digital Rain – Night Passion. Mai 23, 2016. Mai 23, 2016. Schreibe einen Kommentar zu Digital Rain – Night Passion. Apple and Stone – Rain of Shadows. Mai 23, 2016. Mai 23, 2016. Lukas Termena -The Planet.

blog.joachimpettersson.ws

WEBSITE.WS - Your Internet Address For Life™

Your browser does not support frames. Continue to https:/ www.worldsite.ws/idn-orderflow/index.dhtml?