I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date.
When I store the time and then try to check it against the current time I'm runnig into problems.
where (timeofevent = Convert(char(19),current_timestamp))
this doesnt work because Convert(char(19),current_timestamp
returns Nov 6 2005 6:39PM when what I need is 6:39PM or 18:39.
I need help getting the current time in that format.
THANKS!