Re: Week number of the year CASE statement query

2011-08-10 Thread John English
On 10/08/2011 02:24, Conor66 wrote: Hi guys, firstly Id just like to say thank to everyone that has already responded to my questions, People on here are very helpful. What I am trying to do here is get the week number in the year that something happens and then count the amount of times this

Re: Table exists in same JVM after Derby is shutdown

2011-08-10 Thread Kristian Waagan
On 09.08.11 17:14, Pavel Bortnovskiy wrote: Thank you, Kristian. Can you please clarify some of the points you made (or point me to an online primer that describes it): - what is the difference between shutting down a specific db and the whole engine? Shutting down a specific database will

Re: Week number of the year CASE statement query

2011-08-10 Thread Conor66
Thanks for your reply. Yes I looked into Calendar.WEEK_OF_YEAR, I came across it after I wrote that CASE statement and it would definitely be a better way to do this. But Im wondering how to get the weeks where nothing happens, so that I can have zero values also, not just the weeks where