Friday, June 15, 2012

It is "venerdi" in "it" - a Friday idea

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'))

1                                                                                                  
----------------------------------------------------------------------------------------------------
venerdì                                                                                            

  1 record(s) selected.

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