All Forums Database
carlsantos 4 posts Joined 11/09
17 Nov 2009
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 2009Does anyone know how to convert the Month into German?

Jimm 298 posts Joined 09/07
17 Nov 2009

SelectSubstr((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.

carlsantos 4 posts Joined 11/09
18 Nov 2009

Thanks for the workaround!

You must sign in to leave a comment.