Time based welcome greetings

Question

I have a table named @table1 which have two field one LoginDate and another Name field.

Date	Name
01/10/2024 10:00:00 AM	Mr. Deb Kumar
1/10/2024 12:30:00 PM	Mr. Srinibash

I want to create a view @table2 like below;

Greetings	Name
Good Morning	Mr. Deb Kumar
Good Afternoon	Mr. Srinibash

I want if Date field's Time value is between 6:00:00 to 12:00:00 then Greetings will be Good Morning and if Time value is between 4:00:00 to 5:00:00 then Greetings will be Good Afternoon and so on. How can i do this?