brainchime.com Latest Questions

Admin
Asked: 2024-10-06T15:01:47+05:30 In:

How can i derive the week from a YYYYMMDD formatted date?

I have a date field in one of my files and the date is formatted in the YYYYMMDD format. I have to extract the week from the particular date value present in my file. How can I do this using SQL?

FYI, I am using IBM DB2.

as400db2

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin

    We can extract the week from a YYYYMMDD formatted date using the week() function and substr() function. Please use the below SQL query to achieve this.

    select week(substr(char(datefield),1,4) concat '-' concat
            substr(char(datefield),5,2) concat '-' concat
            substr(char(datefield),7,2)) as weeknumber
from libraryname/filename

    or you can simply run the SQL query to test one of the values using a dummy table.

    select week(substr(char(20240909),1,4) concat '-' concat
            substr(char(20240909),5,2) concat '-' concat
            substr(char(20240909),7,2)) as weeknumber
from sysibm.sysdummy1

    The output week is 37.