Thank You! That works ...

Thanks Jeff!!!

Thank You ...

also got solution for this one as well

select ID,

CONVERT(varchar(20),LOADDATE,101) as [Date],

CASE WHEN CAST(LOADDATE AS TIME) > '8:59:59' THEN CONVERT(varchar(20),LOADDATE,101)

ELSE CONVERT(varchar(20),DATEADD(DAY,-1,LOADDATE),101) END AS [NewDate],

CAST(LOADDATE AS TIME) as time

from #temp

below is to get business hours data

SELECT *

FROM #TEMP

WHERE CAST(LOADDATE AS TIME) BETWEEN '9:00:00' AND '17:59:59'

Thanks for your help

Basically actual ask is,

we need to display the date, and rule is the time rage is 9AM to 8:59AM,

<!--more-->

CREATE TABLE #TEMP
(ID INT, LOADDATE DATETIME)

INSERT INTO #TEMP
SELECT 1,'2022-03-24...

I think this might solve this

SELECT *

FROM #TEMP

WHERE cast(LOADDATE as time) BETWEEN '9:00' AND '17:00'

I did tried some, but didn't got desired output what i am looking for.

Thanks!

Thanks Guys,

It helps me to develop in my logic.

Thanks for your reply,

The First Column need to have only one Value before comma, and rest it need to go to other column.

Thanks Guys for helping out to build this.
Appreciate your effort.