I want to convert this SQL query to HANA

[former_member639596]

CREATE FUNCTION [dbo].[AC_FirstDate] () RETURNS DATETIME AS BEGIN DECLARE @Result DATETIME; SELECT @Result = Cast (Cast(Month(getdate()) AS NVARCHAR) + '-01-' + CAST (YEAR(GETDATE()) AS nVARCHAR) AS DATE); RETURN @Result; END

[former_member228588]

You can try below SQL in Hana to replace .

date.png