Select Month Date in German

Database

Select Month Date in German

Hi,

I have this query in teradata:
select current_date (format 'dd.bmmmmbyyyy') (varchar(30));

with this output:
17. November 2009

Does anyone know how to convert the Month into German?
2 REPLIES
Enthusiast

Re: Select Month Date in German

Select

Substr((Current_Date (Format 'dd.bmmmbyyyy')),1,4)||

Trim(CASE Substr((Current_Date (Format 'dd.bmmmbyyyy')),5,3)

WHEN 'Jan' THEN 'Januar'

WHEN 'Feb' THEN 'Februar'

When 'Mar' THEN 'Marz'

WHEN 'Apr' THEN 'April'

WHEN 'May' THEN 'Mai'

WHEN 'Jun' THEN 'Juni'

WHEN 'Jul' THEN 'Juli'

WHEN 'Aug' THEN 'August'

WHEN 'Sep' THEN 'September'

WHEN 'Oct' THEN 'Oktober'

WHEN 'Nov' THEN 'November'

WHEN 'Dec' THEN 'Dezember' END)||

Substr((Current_Date (Format 'dd.bmmmbyyyy')),8,5)

if you are using bteq.
If you are using Cognos or any of the other BI tools, you can retrieve a numeric date and get the tool to do the localisation.

Re: Select Month Date in German

Thanks for the workaround!