Hi,
i try convert from SQL to TERA :
DECLARE @DateIn DATETIME = GETDATE()
DECLARE @StartNumDays INT
DECLARE @EndNumDays INT
declare @DaysBack int = 180
declare @DaysBackDate int = convert(int,convert(varchar(20),getdate()-@DaysBack,112))
DECLARE @STARTDATE DATETIME = cast(convert(char(10),dateadd(day, -@StartNumDays, @DateIn ), 101 )AS datetime)
DECLARE @ENDDATE DATETIME = cast(convert(char(10),dateadd(day, -@EndNumDays, @DateIn ), 101 )AS datetime)
someone know how to write it correct.
Thanks & Best Regards
declare @DaysBackDate int = convert(int,convert(varchar(20),getdate()-@DaysBack,112)) = CAST(CURRENT_DATE - @DaysBack AS INT) + 19000000 DECLARE @STARTDATE DATETIME = cast(convert(char(10),dateadd(day, -@StartNumDays, @DateIn ), 101 )AS datetime) = CAST(CURRENT_DATE - @StartNumDays AS TIMESTAMP)
Are you working with Dates or Timestamps?