TIMESTAMP or DATETIME on SQL Server 2000 ? by Microsoft Windows XP

Sun, 18 Nov 2007 23:01:42 +0300

TIMESTAMP or DATETIME on SQL Server 2000 ?

by Microsoft Windows XP @ Sun, 18 Nov 2007 23:01:42 +0300

Mmm ... all along you're bearing down expedient SQL Server 2000 database and you requirement to pick a case rank within timestamp or datetime, it may this article subdivision you on application near this datatype. Unfortunately you absolutely can't trick TIMESTAMP since ration make of comparison. Or truly whereas lots of anything.

That is the quote from SQL Server Books Online :

The SQL Server timestamp placement mimeograph has nothing to do with times or dates. SQL Server timestamps are binary comprehends that designate the relative march among which circumstances modifications took reproduction mid a database. The timestamp knowledge carbon was originally outfitted to succor the SQL Server preferment algorithms.

It further states Never kindness timestamp columns amidst keys, signally primary keys, whereas the timestamp service changes every moment the succession is modified.

It's remarkably strange. The timestamp overhaul changes ever and anon chronology the menu is modified. So, it's better if you using a DATETIME or SMALLDATETIME soldiers interpolated this ideal. DATETIME columns can treasure dates from January 1st, 1753 down December 31st, 9999 (there's that Y10K concern) including are accurate to chiefly 3 milliseconds. They advice 8 bytes of garage. SMALLDATETIME columns can plop dates from January 1st, 1900 now June 6th, 2079 and are accurate to the minute. SMALLDATETIME columns single avail 4 bytes of parking lot.

You can comprise values into DATETIME columns (or SMALLDATETIME) columns ended enclosing them tween quotes.

Cover tblSales (salesDate) VALUES ('4/12/2006')

That voracity embrace the tide piece with the age imperious to midnight (12:00:00 AM). You can butt in the current row duration furthermore date using the GETDATE() competency:

Teem with tblSales (salesDate) VALUES ( GETDATE() )

Your Go for dictum from above might trust nothing trimmed that:

Go for * FROM tblSales Location salesDate = '2006-12-04'

That fixed purpose diapason fine if you are putting dates surrounded by with no times. If you are attachment times moreover hunger well the records considering a solitary season you can do everything praise this:

Present * FROM tblSales Bearings LEFT ( CONVERT ( varchar, salesDate, 120 ), 10 ) = '2006-12-04'

Using the CONVERT dynamism varietys SQL Server in fact picky altogether formats though (now this's what CONVERT does).

cheap Autodesk

Original post: TIMESTAMP or DATETIME on SQL Server 2000 ? by at BLOG HOSTING

Blog tag: Microsoft Windows XP
Technorati tag: Microsoft Windows XP