Interval - Date and Time separation? - UCCE v11.6

[Bill.Huynh.RSM]

Is it possible to separate the intervals which are reported as the full date string INCLUDING the timeframe, into date separately from time?  I'm looking to collect data per time interval regardless of date and have yet to find a solution for it.

[Marek (gaman-gt.com)]

Hi Bill,

To separate date and time you can use the CONVERT function with the format description:

CONVERT(NVARCHAR, DateTime, Format)

Available formats can be found here: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/.

You will need to modify interval queries and reports by adding the additional select for the date and time conversion.