SQL Time?

Results 1 to 2 of 2

Thread: SQL Time?

  1. #1
    man Guest

    Default SQL Time?

    I currently have a field in my DB set as smallDateTime and want to pull the Time out using a Stored Procedure, i know how to do it in VB but cannot figure out how to pull just the time out in a stroed proc??<BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Time?

    &nbsp;<BR><BR>Well grab the hour and minute using Datepart<BR><BR>select DatePart(h,datecol) as hr .....<BR><BR>read up on it in the t-sql help.

Posting Permissions

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