i have a scenario where i have to calculate the difference between two time formats(24 hr-- hh:mm) which are in varchar data type.this result may be the working hours of an employee.
There are CAST and CONVERT functions that allow you to convert your VARCHAR functions to TIME format.. Please have a look-see at Books Online (A free help system that comes with SQL Server installation) or in MSDN online on how that is done..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply