Debashish Mahonta

Debashish Mahonta

  • 1.5k
  • 148
  • 3k

Time based welcome greetings

Oct 1 2024 11:41 AM

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?


Answers (7)