It is \

It is Friday and close to afternoon. What to do next? I type “Friday” into the search field of the DB2 Information Center and in the result list I notice the function DAYNAME. In the description I notice that I can provide a locale or language code as parameter.

Let’s give it a try, it is Friday afternoon:

db2 => values(dayname(current date))

1

Friday

1 record(s) selected.

db2 => values(dayname(current date, ‘de’))

1

Freitag

1 record(s) selected.

db2 => values(dayname(current date,‘fr’))

1

vendredi

1 record(s) selected.

db2 => values(dayname(current date,’es’))

1

viernes

1 record(s) selected.

db2 => values(dayname(current date,‘in’))

1

Jumat

1 record(s) selected.

db2 => values(dayname(current date,'**it**'))

----------------------------------------------------------------------------------------------------

**venerdì**

  1 record(s) selected.

If your language or country is not listed, try it yourself. Have a nice weekend.