SELECT a.*, Datename(mm,a.[f_Periode]) + ' ' + Datename(yy,a.[f_Periode]) as l_Periode, Convert(varchar(10), month(a.[f_Periode])) + Datename(yy, a.[f_Periode]) as m_Periode, Convert(varchar(10), month(a.[f_Periode])) + '/' + right(datename(yyyy, a.f_periode), 2) AS f_Ausgabe, Convert(varchar(10), day(a.[f_periode])) + '/' + Convert(varchar(10), month(a.[f_periode])) + '/' + Convert(varchar(10), year(a.[f_periode])) AS fperiode FROM sacmyth_webuser.tbl_Settings a order by f_Periode;
|