Hot answers tagged

1

Try this: WITH T (YYYYMMDD, HHMM) AS ( VALUES (20200304, 1046) -- return a timestamp for April 3, 2020, 10:46 AM. , (20200304, 946) -- return a timestamp for April 3, 2020, 9:46 AM. , (20200304, 2359) -- return a timestamp for April 3, 2020, 11:59 PM. , (20200304, 0) -- return a timestamp for April 3, 2020, 0:00 AM. ) SELECT YYYYMMDD, HHMM , ...


Only top voted, non community-wiki answers of a minimum length are eligible