a guest Aug 20th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT * FROM Market WHERE AssetPairId = '1' AND [Time] BETWEEN '1565521380' AND '1566334368'
- Volume, High, Low, [Open], [Close], Time
- select convert(date, timestampcol) as dte, sum(col1), . . .
- from t
- group by convert(date, timestampcol)
- order by convert(date, timestampcol);
RAW Paste Data