hello, its me again
this time i tried to execute a CASE query to set time of day as either morning, afternoon or evening.
it runs without error but my problem is all the times return as evening..
what can i do?

You are applying CASE on a column.
So you need to remove the single quotes from the column name 'time'.
case when time between


it worked.. Thank You venerable Sensei

1 Like