Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

DATETIME - 4 Expand / Collapse
Author
Message
Posted Saturday, March 16, 2013 2:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:36 PM
Points: 5,572, Visits: 24,800
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
Posted Saturday, March 16, 2013 2:31 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 7:42 PM
Points: 8,567, Visits: 9,071
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest.

Tom
Post #1431944
Posted Sunday, March 17, 2013 10:32 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
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
Posted Sunday, March 17, 2013 11:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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
Posted Sunday, March 17, 2013 11:13 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
very good question to start of the week..


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1432078
Posted Sunday, March 17, 2013 11:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
kapil_kk (3/17/2013)
very good question to start of the week..






Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1432079
Posted Monday, March 18, 2013 3:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:12 AM
Points: 852, Visits: 1,930
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
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1432110
Posted Monday, March 18, 2013 4:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
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
Posted Monday, March 18, 2013 4:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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
Posted Monday, March 18, 2013 5:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:20 AM
Points: 1,767, Visits: 2,141
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.
Connect to me on LinkedIn
Post #1432136
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse