Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    115

    Question Unanswered: time format - what's the smallest unit SQL 2005 can take?

    saw my AS400 has this time stamp: 2007-05-02-11.29.56.811195

    is SQL2005 able to have time stamp to this details?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    No

    From BoL:
    Date and time data from January 1, 1753, to December 31, 9999, with an accuracy of one three-hundredth second, or 3.33 milliseconds. Values are rounded to increments of .000, .003, or .007 milliseconds.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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