tag:blogger.com,1999:blog-7395977411859619892.post821075621531119778..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: Date format element 'ww'Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7395977411859619892.post-23371644513464316772013-03-19T12:06:54.424+01:002013-03-19T12:06:54.424+01:00Hi Rob,
thats a great blog. Thanks for publish.
...Hi Rob,<br /><br />thats a great blog. Thanks for publish.<br /><br />Cheers <br /><br />Asteriosastrapi69https://www.blogger.com/profile/02514044002235589463noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-40865015827439375442009-01-16T22:13:00.000+01:002009-01-16T22:13:00.000+01:00Mikey,The answer depends on how you define your we...Mikey,<BR/><BR/>The answer depends on how you define your weeks: according to Oracle's WW-format, or ISO-weeks, or anything else?<BR/><BR/>And it depends on your definition of "first day of the week". This usually is sunday or monday, but it differs per country.<BR/><BR/>A random shot:<BR/><BR/>rwijk@ORA11GR1> var YEAR number<BR/>rwijk@ORA11GR1> var WEEK number<BR/>rwijk@Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-12366342676866582952009-01-09T23:19:00.000+01:002009-01-09T23:19:00.000+01:00I'm trying to come up with an Oracle function do g...I'm trying to come up with an Oracle function do give me the PROPER first day of the week as per your article. I know how to do it in sql server but haven't a clue in oracle. <BR/><BR/>here's the sql server function passing in week 52 and year 2008 and returning 12/21/2008Mikeyhttps://www.blogger.com/profile/14220728400567367828noreply@blogger.com