Results 1 to 3 of 3

Thread: To obtain time part from a date?

  1. 07-24-2006, 11:21 AM #1
    ranga_xp
    ranga_xp is offline Registered User
    Join Date
    Jan 2005
    Location
    Pune
    Posts
    19

    To obtain time part from a date?

    Is there any other alternative for getting time part of a datetime type variable than using datepart()?
    Reply With Quote Reply With Quote
  2. 07-24-2006, 12:17 PM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    What specifically do you want to get? If you want the entire time part, how about: CONVERT(varchar, getdate(), 108)
    Reply With Quote Reply With Quote
  3. 07-24-2006, 12:31 PM #3
    ranga_xp
    ranga_xp is offline Registered User
    Join Date
    Jan 2005
    Location
    Pune
    Posts
    19
    Yes, I wanted the same. Thanks for your help.
    As I need the miliseconds to, I'll use 114 instead of 108

    CONVERT(varchar, getdate(), 114).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules