Skip to Content
0

I want to convert this SQL query to HANA

Mar 06, 2017 at 04:35 PM

42

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

You can try below SQL in Hana to replace .

date.png


date.png (6.6 kB)
Share
10 |10000 characters needed characters left characters exceeded