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?
@ahmeds08
You are applying CASE on a column.
So you need to remove the single quotes from the column name 'time'.
case when time between
2 Likes
it worked.. Thank You venerable Sensei
1 Like