<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by bitbucket
»
DATETIME - 4
29 posts, Page 1 of 3
1
2
3
»
»»
DATETIME - 4
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
bitbucket-25253
Posted Saturday, March 16, 2013 2:09 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 9:12 PM
Points: 5,103,
Visits: 20,208
Comments posted to this topic are about the item
DATETIME - 4
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1431941
L' Eomot Inversé
L' Eomot Inversé
Posted Saturday, March 16, 2013 2:31 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:12 AM
Points: 7,106,
Visits: 7,171
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1431944
demonfox
demonfox
Posted Sunday, March 17, 2013 10:32 PM
Ten Centuries
Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074,
Visits: 1,076
L' Eomot Inversé (3/16/2013)
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest.
+1
May be, because, it's monday it looked like too much english and a long script to read . Then, I finally decided to go on with the question .. In the end, I realised it is a question about datetime millisecond precision
eventually it was a worthy read ,a simple query with calm mind ...
thanks for the question
Edit: english
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1432074
Lokesh Vij
Lokesh Vij
Posted Sunday, March 17, 2013 11:07 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176,
Visits: 1,253
demonfox (3/17/2013)
L' Eomot Inversé (3/16/2013)
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest.
+1
May be, because, it's monday it looked like too much english and a long script to read . Then, I finally decided to go on with the question .. In the end, I realised it is a question about datetime millisecond precision
eventually it was a worthy read ,a simple query with calm mind ...
thanks for the question
Edit: english
+2
Also good to see sql 2012 function "DATETIMEFROMPARTS" as well.
Thanks Ron!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1432076
kapil_kk
kapil_kk
Posted Sunday, March 17, 2013 11:13 PM
Ten Centuries
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061,
Visits: 1,151
very good question to start of the week..
Post #1432078
Danny Ocean
Danny Ocean
Posted Sunday, March 17, 2013 11:31 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 1,085,
Visits: 1,163
kapil_kk (3/17/2013)
very good question to start of the week..
Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in
Thanks
Vinay Kumar
Post #1432079
Raghavendra Mudugal
Raghavendra Mudugal
Posted Monday, March 18, 2013 3:07 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 446,
Visits: 1,199
Awesome Qtod,thank you for posting.
(I am bursting with my doubts... but no idea where to begin...)
so to say... there will be no row/s in the datetime column where it ends with other than these .000, .003 or .007. Like .004 turns to .003 or .129 turns in to .127.... ? .002 changes to .003?
My main doubt is... in the BOL it says under property as "accuracy" and then the corresponding value starts with " rounded to increment..." ? what type of accuracy is this?
edit; fixed the "property" spell
ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.
Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1432110
demonfox
demonfox
Posted Monday, March 18, 2013 4:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074,
Visits: 1,076
Raghavendra Mudugal (3/18/2013)
Awesome Qtod,thank you for posting.
(I am bursting with my doubts... but no idea where to begin...)
so to say... there will be no row/s in the datetime column where it ends with other than these .000, .003 or .007. Like .004 turns to .003 or .129 turns in to .127.... ? .002 changes to .003?
My main doubt is... in the BOL it says under property as "accuracy" and then the corresponding value starts with " rounded to increment..." ? what type of accuracy is this?
edit; fixed the "property" spell
I found this out while migrating data on a datetime, that too from sybase datetime (i think it's 3 6 9 in millisecond for sybase datetime) , had to convert it to datetime2 for exactness..
yes, it is mentioned in bol ..the accuracy and the behaviour and cost fo this accuracy ...
so use as you wish .. and ignore as you wish ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1432126
Lokesh Vij
Lokesh Vij
Posted Monday, March 18, 2013 4:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176,
Visits: 1,253
demonfox (3/18/2013)
so use as you wish .. and ignore as you wish ..
????
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1432127
Thomas Abraham
Thomas Abraham
Posted Monday, March 18, 2013 5:04 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 2:04 PM
Points: 1,150,
Visits: 1,455
Thanks for the question Ron. I usually do the QOTD within ten minutes of rising in the morning. So, it helps when it's short. Or, as in this case, on a basic topic. Or, when I guess correctly!
Please don't go. The drones need you. They look up to you.
Post #1432136
« Prev Topic
|
Next Topic »
29 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
