How to get column value like this in sql?

Question

intime  outtime  21-03-2017 09:01:22  21:03:2017 20:00:00 My expected output like this   intime  OTIN  OTOUT  outtime  21-03-2017 09:01:22   21-03-2017 18:01:22   21-03-2017 18:01:22   21-03-2017 20:00:00     if outtime is greater then 08pm (20:00) means OTIN time assigned as  06 pm(10:00) same Time as OTOUT finally outtime as Outtime

Madhanmohan Devarajan · Answer

Would like to understand your requirement. Please let me know whether you are trying to get and set values to fields OTIN OTOUT  from Front-end to SQL DB ? Based on the condition if outime greater than "20:00:00" it should automatically fill in the values of OTIN and OTOUT. You would like to view those values in the form if it satisfies the condition?

intime	OTIN	OTOUT	outtime
21-03-2017 09:01:22	21-03-2017 18:01:22	21-03-2017 18:01:22	21-03-2017 20:00:00