Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Possible to add seconds and millisecond resolution to all datetime field types?

My line of work requires datetime precision down to the millisecond. If it is possible would it be okay to add at least second person and ideally millisecond precision to any datetime field?
1 person likes
this idea
+1
Reply
  • Hi Dave,

    The millisecond precision in the datetime format of SQL Server is supported by Microsoft SQL Server 2008 and up. If your SQL Server is version 2005 or less, the server does not support milliseconds in datetime and so won't the app.

    I hope this answered your question.

    Regards,
    Mickel

    DISCLAIMER TO THIS REPLY
    I am a DataGlass customer and offer limited support in this forum. All my replies are based on my experiences with DataGlass products. I do not guarantee any solution. You are solely responsible for using the answers that I posted on this forum.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned