SQL Server does not have a format that formats the time to hh:mm AM/PM or just hh:mm without the seconds. Is there a way to use code in a stored procedure to display just the hh:mm without the seconds? <BR>
you can use datepart function. please refer online book for sql server. you can get the syntax for the datepart function which can be used in the stored procedure.
thanks, I think that will work.