I am using db2 with a date filed formatted as 20141110, which is November 10, 2014 in my sql query using Visual Studio 2013 I am trying to wonder how do I get the week number from the date field, which should be week 46. Any tips will be appreciated. Thank you in advance.