Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    12

    Question Unanswered: Extract and compare hour

    Hi all:

    As I can extract the hour values and minute of a field of type datetime to compare it with the values of a field of type smalldatetime of another table

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Yes. Look at DatePart in BOL.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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