I have a stored procedure that returns appointment data into a form. Everything was working fine but I've been tasked with the following:
1. If the appointment is flagged as appAllDay = 1, the appointment start time (appDate) needs to display with a different time. The physical data isn't touched or changed.
For example, 2010-02-05 08:00:00.000 needs to display as 2010-02-05 11:00:00.000 in my appTime column shown below.
The appDate field is a datetime column so I'm not sure if this is even possible. Any assistance would be appreciated.
(case appAllDay when 0 then appDate else
end) as appTime
WHERE dbo.dbAppointments.feeusrid = 7459