i'm using a starttime, stoptime, duration combination of columns. i'm using datetime for the first two to get a time stamp for the start and stop. the issue is that i want to display "00:00" for start and stop time if the session has not been started yet.
is this possible??? what is the best course of action to tackle this problem??
CONVERT(varchar(10),Getdate(),101)+' 00:00:00' is going to display midnight of the current day. Is that what you want? If you are looking for a "zero-time" setting, that's trickier. Microsoft time goes back, what 1900? Western zero-time goes back to Jesus (give or take a few years). Universal time goes back to the Big Bang, but you'll definitely need the BigInt datatype for that...
Simpler to use NULL.
If it's not practically useful, then it's practically useless.