Skip to Content
avatar image
Former Member

I want to convert this SQL query to HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 06, 2017 at 05:00 PM

    You can try below SQL in Hana to replace .

    date.png

    Add comment
    10|10000 characters needed characters exceeded