title: Teradata Equivalent to this SQL Server DATETIME code?
body: <p>Hi I am unfamiliar with SQL Server and need to translate this into usable Teradata SQL. Can anyone assist? Many Appreciations.</p>
  
  <pre><code>DECLARE @StartDate DATETIME
  DECLARE @EndDate DATETIME
  
  SET @StartDate = CAST(DATEPART(MM, GETDATE())-1 AS VARCHAR) + '/01/' + 
      CAST(DATEPART(YYYY, GETDATE()) AS VARCHAR)
  
  SET @EndDate = EOMONTH(@StartDate)
  
  --This will allow you to see the values without having to run a select query filter.
  PRINT @StartDate
  PRINT @EndDate
  
  SELECT * 
  FROM Product
  WHERE DateCreated BETWEEN @StartDate AND @EndDate
  </code></pre>