Time Format to hh:mm AM/PM in stored procedure

Results 1 to 3 of 3

Thread: Time Format to hh:mm AM/PM in stored procedure

  1. #1
    Norman King Guest

    Default Time Format to hh:mm AM/PM in stored procedure

    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>

  2. #2
    nupur chokshi Guest

    Default RE: Time Format to hh:mm AM/PM in stored procedure

    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.

  3. #3
    Cable Guest

    Default RE: Time Format to hh:mm AM/PM in stored procedure

    thanks, I think that will work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •