getdate() accuracy
-
SQLServerLifer (5/15/2008)
The GETDATE() function returns a DATETIME type. Therefore it will inherit the same rounding limitation.Yes, but it might add "Limitations" of its own. In particular (and what this discussion is really about), the internal speed or increment of the "clock" that SQL Server is using may be larger than 3.33ms. If fact, it may be 13 or 14ms.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Oops, apparently, I was a little late to this party (even Matt got here before me!), but I believe that it is now apparent what I was saying above: this is an issues with the SQL Server* Clock resolution, and NOT the resolution of the datatype.
*(note that an application or sw server's clock is not necessairly the same as the system's clock, but it's resolution is normaly always a multiple (1 or more) of the system clock's resolution, never less (without special hardware)).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
rbarryyoung (5/16/2008)
...(even Matt got her before me!)...Hey now! where the heck did THAT come from??? :hehe::w00t:
Sheesh - travel home to see the wife, and get smacked around on the boards...:)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again? -
Well, that's better than the other way around, Matt! 😀
-
Matt Miller (5/16/2008)
rbarryyoung (5/16/2008)
...(even Matt got here before me!)...Hey now! where the heck did THAT come from??? :hehe::w00t:
Sheesh - travel home to see the wife, and get smacked around on the boards...:)
From you & Jack, mostly 😀 ...
here: http://qa.sqlservercentral.com/Forums/FindPost468098.aspx
and here: http://qa.sqlservercentral.com/Forums/FindPost468108.aspx
Hey, I don't make this stuff up! I make other stuff up, but not this stuff! 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
John Beggs (5/16/2008)
Well, that's better than the other way around, Matt! 😀No arguing with ya there:)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again? -
rbarryyoung (5/16/2008)
Matt Miller (5/16/2008)
rbarryyoung (5/16/2008)
...(even Matt got here before me!)...Hey now! where the heck did THAT come from??? :hehe::w00t:
Sheesh - travel home to see the wife, and get smacked around on the boards...:)
From you & Jack, mostly 😀 ...
here: http://qa.sqlservercentral.com/Forums/FindPost468098.aspx
and here: http://qa.sqlservercentral.com/Forums/FindPost468108.aspx
Hey, I don't make this stuff up! I make other stuff up, but not this stuff! 🙂
No issue - just wanted to know what I was getting smacked with:) Just about all is fair in pretty much every aspect on a Friday afternoon!
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again? -
:crazy: Blimey! Whats with all of the smiley faces? :unsure: We've got more yellow dots here than a teenage fanboy with a chocolate addiction! :w00t:
😉
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Heh... what yellow dots?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions -
Jeff Moden (5/16/2008)
Heh... what yellow dots?OK, now that's just wrong!
I'm keeping my eye(s) on you mister...
And don't think that I haven't noticed that your "No RBAR" avatar is really just crossing out the first 4 characters of my name. Coincidence? I think not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Heh... LMAO!!! That's funny... RBARry Young... hadn't thought of that. :hehe:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions -
Yeah? Well let's jst see what happens when we extract your avatar and uncover the hidden right side:
Ha! I knew it!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Way too funny! 🙂 Heh, I guess THAT's why Steve limits the size of the Avatars :hehe:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions -
Shifting gears a bit, Barry... do you realize the link in your signature line is broken?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions -
yeah, I can't figure out why though. I've got the right address in the IFcode, but somehow its coming out with this rogue pointer.
Here's what I put in:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font]
[font="Arial Black"]Proactive Performance Solutions, Inc.[/font][font="Verdana"] "Performance is our middle name."[/font]
You should be able to see it raw if you Quote my post...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply