Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Southern California
    Posts
    2

    Unanswered: time granularity

    We are new to Sybase, and one of our programmers said that Sybase tracks time to the nanosecond as opposed to Microsoft SQL Server which only tracks time to the millisecond (actually to the clock tick). This nanosecond granularity doesn't sound right to me, and I can't find any reference to nanoseconds in the ASE Transact SQL User Guide. Is our programmer smoking crack (figuratively)?

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353

    Re: time granularity

    Originally posted by richmondata
    We are new to Sybase, and one of our programmers said that Sybase tracks time to the nanosecond as opposed to Microsoft SQL Server which only tracks time to the millisecond (actually to the clock tick). This nanosecond granularity doesn't sound right to me, and I can't find any reference to nanoseconds in the ASE Transact SQL User Guide. Is our programmer smoking crack (figuratively)?
    Time granularity is one 300th of a second. So although a datetime value will show you milliseconds, the minimum increment is 1/300th of a second.

    Michael

Posting Permissions

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