SQL, Datumsfunktionen

[Ilja]

yo,

select
 CASE
  WHEN '01.02.' + CAST(YEAR(GETDATE()) AS CHAR) < GETDATE()
  THEN '01.08.' + CAST(YEAR(GETDATE()) AS CHAR)
  ELSE '01.02.' + CAST(YEAR(GETDATE()) AS CHAR)
 END

Ilja