Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    15

    Unanswered: time from datetime

    Hi,

    I am using MSDE2000
    I am unable to update a record with a comparison on a datetime field which is actually storing only the time value.

    e.g,

    Update tblMyTable set
    MyTimeField='15:38:23' where
    MyTimeField='15:37:28'

    Here, MyTimeField is a datetime field.

    Thanks and regards,
    henry

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What about this?

    select convert(varchar,getdate(),8)

  3. #3
    Join Date
    Nov 2003
    Posts
    15

    thanks .. it works :-) <EOM>

    Originally posted by snail
    What about this?

    select convert(varchar,getdate(),8)

Posting Permissions

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