Monday, January 21, 2019

SQL select with timestamp

SELECT ...
FROM ...
WHERE MyDate BETWEEN '2005-07-12 07:00:00' and '2005-07-12 08:00:00'

SELECT TOP (9) [Volume]
      ,[Open]
      ,[High]
      ,[Low]
      ,[Close]
      ,[WAP]
      ,[Count]
      ,[dt]
      ,[EMA9]
      ,[EMA10]
      ,[EMA20]
      ,[EMA21]
      ,[EMA50]
      ,[EMA100]
      ,[EMA200]
  FROM [market_data].[dbo].[NFLX]

  WHERE dt <= '2019-01-18 19:42:00'

No comments:

Post a Comment