new date datatypes in sql server 2008 tech republic

New Date Datatypes in SQL Server 2008 | TechRepublic

http://www.techrepublic.com/blog/datacenter/new-date-datatypes-in-sql-server-2008/443[08/29/2012 3:44:51 PM]

Blogs Downloads Newsletters Galleries Q&A Discussions News

Research Library

Home / Blogs / The Enterprise Cloud

The Enterprise Cloud

New Date Datatypes in SQLServer 2008

Btrieve 6.15 ForeverStill using Btrieve? So are we! Get the UltimateBtrieve Patchpervasivedb.com/btrieve

Improve ProductivityApps For Business- 30 Day Free Trial. NoCredit Card Required!www.google.com/apps

OTM (G-Log) SolutionsAt MavenWire, We Offer Solutions to MeetYour Business Needs. Visit Us!www.MavenWire.com

Keep Up with TechRepublic

By Tim ChapmanSeptember 8, 2008, 10:59 AM PDT

Takeaway: SQL Server 2008 provides new data-types for storing wider ranges of dates withmore precision. Heres can you can use these new data types to your advantage in SQL Server2008.

As a database architect, one of the features I am most excited about in SQL Server 2008 is thenew date related data types. These data types allow for the storage of time-only data, date-onlydata, a larger range of date values, more time precision, and the ability to store time-zone specificdates. Today Ill take a look at these great new data types and how they can be used to expandyour date storage possibilities.

DATEThe new DATE data-type defines a date field without any associated time. In previous versions ofSQL Server, storing time-only data was accomplished in one of two ways. First, you could defineeither a DATETIME or SMALLDATETIME data type and assign the value as a VARCHAR value.Then you would need to handle the time related data in your queries. The other way is to store thedate value in a VARCHAR field in the database. Either way, handling date-only data was at bestcumbersome. With the new DATE data-type, it intrinsically stores only date values. In the followingexample I define a DATE data-type and a DATETIME data type and assign todays date to thevariables. As you can see from SELECTing the values from the variables, the DATE variable holdsonly the date portion whereas the DATETIME field also stores the associated time from theGETDATE() function.

DECLARE @TodaysDate DATE = GETDATE()

DECLARE @TodaysDateTime DATETIME = GETDATE()

SELECT @TodaysDate, @TodaysDateTime

Storing DATE specific data will also make queries easier to write. Instead of using one of thefollowing statements to pull data for a DATETIME column;

SELECT * FROM SalesHistory

WHERE SaleDate >= 4/11/2008' AND SaleDate < 4/12/2008'

you can use an equality operator (=) to search only for the specific date, assuming theSaleDateOnly field is defined as a DATE data-type.

SELECT * FROM SalesHistory

WHERE SaleDateOnly = 4/11/2008'

Follow this blog:

Five Apps

Google in the Enterprise

Subscribe Today

Follow us however you choose!

IT Management Development IT Support Data Center Networks Security

Log In Join TechRepublic FAQ Go Pro!ZDNet Asia SmartPlanet TechRepublic

http://ad.doubleclick.net/click;h=v8/3ce0/0/0/%2a/d;44306;0-0;0;74341537;31-1/1;0/0/0;;~sscs=%3fhttp://www.techrepublic.com/http://www.techrepublic.com/http://www.techrepublic.com/blogshttp://www.techrepublic.com/downloadshttp://www.techrepublic.com/newslettershttp://www.techrepublic.com/photoshttp://www.techrepublic.com/forum/questionshttp://www.techrepublic.com/forum/discussionshttp://www.techrepublic.com/newshttp://www.techrepublic.com/research-libraryhttp://www.techrepublic.com/http://www.techrepublic.com/blogshttp://www.techrepublic.com/blog/datacenterhttp://ad.doubleclick.net/click;h=v8/3ce0/0/0/%2a/j;44306;0-0;0;74341537;3823-300/100;0/0/0;;~sscs=%3fhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BqGwfe9Y9ULC8LsSNlALH_oC4CNu1rjmb5YHuGMCNtwGQqokBEAEYASDaxfUDKAM4AFDz4tzeB2B1sgEUd3d3LnRlY2hyZXB1YmxpYy5jb23IAQHaAVZodHRwOi8vd3d3LnRlY2hyZXB1YmxpYy5jb20vYmxvZy9kYXRhY2VudGVyL2hlbHAtbXktc3FsLXNlcnZlci1sb2ctZmlsZS1pcy10b28tYmlnLzQ0OMgCv522AagDAegD1wL1AwIAAETgBt2GMg&num=1&sig=AOD64_2_TihEEZvGbV_j0jlaI_1l50_UJg&client=ca-cnet-techrepublic-content&adurl=http://www.pervasivedb.com/btrieve/Pages/BtrieveUltimate.aspxhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BqGwfe9Y9ULC8LsSNlALH_oC4CNu1rjmb5YHuGMCNtwGQqokBEAEYASDaxfUDKAM4AFDz4tzeB2B1sgEUd3d3LnRlY2hyZXB1YmxpYy5jb23IAQHaAVZodHRwOi8vd3d3LnRlY2hyZXB1YmxpYy5jb20vYmxvZy9kYXRhY2VudGVyL2hlbHAtbXktc3FsLXNlcnZlci1sb2ctZmlsZS1pcy10b28tYmlnLzQ0OMgCv522AagDAegD1wL1AwIAAETgBt2GMg&num=1&sig=AOD64_2_TihEEZvGbV_j0jlaI_1l50_UJg&client=ca-cnet-techrepublic-content&adurl=http://www.pervasivedb.com/btrieve/Pages/BtrieveUltimate.aspxhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BqGwfe9Y9ULC8LsSNlALH_oC4CNu1rjmb5YHuGMCNtwGQqokBEAEYASDaxfUDKAM4AFDz4tzeB2B1sgEUd3d3LnRlY2hyZXB1YmxpYy5jb23IAQHaAVZodHRwOi8vd3d3LnRlY2hyZXB1YmxpYy5jb20vYmxvZy9kYXRhY2VudGVyL2hlbHAtbXktc3FsLXNlcnZlci1sb2ctZmlsZS1pcy10b28tYmlnLzQ0OMgCv522AagDAegD1wL1AwIAAETgBt2GMg&num=1&sig=AOD64_2_TihEEZvGbV_j0jlaI_1l50_UJg&client=ca-cnet-techrepublic-content&adurl=http://www.pervasivedb.com/btrieve/Pages/BtrieveUltimate.aspxhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BqGwfe9Y9ULC8LsSNlALH_oC4CNu1rjmb5YHuGMCNtwGQqokBEAEYASDaxfUDKAM4AFDz4tzeB2B1sgEUd3d3LnRlY2hyZXB1YmxpYy5jb23IAQHaAVZodHRwOi8vd3d3LnRlY2hyZXB1YmxpYy5jb20vYmxvZy9kYXRhY2VudGVyL2hlbHAtbXktc3FsLXNlcnZlci1sb2ctZmlsZS1pcy10b28tYmlnLzQ0OMgCv522AagDAegD1wL1AwIAAETgBt2GMg&num=1&sig=AOD64_2_TihEEZvGbV_j0jlaI_1l50_UJg&client=ca-cnet-techrepublic-content&adurl=http://www.pervasivedb.com/btrieve/Pages/BtrieveUltimate.aspxhttp://googleads.g.doubleclick.net/aclk?sa=l&ai=BcWTie9Y9ULC8LsSNlALH_oC4CLTn-bEC1LKjzzDAjbcBsKiUARACGAIg2sX1AygDOABQjsi1z_z_____AWB1oAGe8_HuA7IBFHd3dy50ZWNocmVwdWJsaWMuY29tyAEB2gFWaHR0cDovL3d3dy50ZWNocmVwdWJsaWMuY29tL2Jsb2cvZGF0YWNlbnRlci9oZWxwLW15LXNxbC1zZXJ2ZXItbG9nLWZpbGUtaXMtdG9vLWJpZy80NDioAwHoA9cC9QMCAABE4Aa6_PwR&num=2&sig=AOD64_0FyQ38c1EZhvo03jtBJZfNvHPT2A&client=ca-cnet-techrepublic-content&adurl=http://clickserve.dartsearch.net/link/click%3Flid%3D43700003450913646%26ds_s_kwgid%3D58700000030950134%26ds_e_adid%3D12987664460%26ds_e_matchtype%3Dcontent%26ds_url_v%3D2http://googleads.g.doubleclick.net/aclk?sa=l&ai=BcWTie9Y9ULC8LsSNlALH_oC4CLTn-bEC1LKjzzDAjbcBsKiUARACGAIg2sX1AygDOABQjsi1z_z_____AWB1oAGe8_HuA7IBFHd3dy50ZWNocmVwdWJsaWMuY29tyAEB2gFWaHR0cDovL3d3dy50ZWNocmVwdWJsaWMuY29tL2Jsb2cvZGF0YWNlbnRlci9oZWxwLW15LXNxbC1zZXJ2ZXItbG9nLWZpbGUtaXMtdG9vLWJpZy80NDioAwHoA9cC9QMCAABE4Aa6_PwR&num=2&sig=AOD64_0FyQ38c1EZhvo03jtBJZfNvHPT2A&client=ca-cnet-techrepublic-content&adurl=http://clickserve.dartsearch.net/link/click%3Flid%3D43700003450913646%26ds_s_kwgid%3D58700000030950134%26ds_e_adid%3D12987664460%26ds_e_matchtype%3Dcontent%26ds_url_v%3D2http://googleads.g.doubleclick.net/aclk?sa=l&ai=BcWTie9Y9ULC8LsSNlALH_oC4CLTn-bEC1LKjzzDAjbcBsKiUARACGAIg2sX1AygDOABQjsi1z_z_____AWB1oAGe8_HuA7IBFHd3dy50ZWNocmVwdWJsaWMuY29tyAEB2gFWaHR0cDovL3d3dy50ZWNocmVwdWJsaWMuY29tL2Jsb2cvZGF0YWNlbnRlci9oZWxwLW15LXNxbC1zZXJ2ZXItbG9nLWZpbGUtaXMtdG9vLWJpZy80NDioAwHoA9cC9QMCAABE4Aa6_PwR&num=2&sig=AOD64_0FyQ38c1EZhvo03jtBJZfNvHPT2A&client=ca-cnet-techrepublic-content&adurl=http://clickserve.dartsearch.net/link/click%3Flid%3D43700003450913646%26ds_s_kwgid%3D58700000030950134%26ds_e_adid%3D12987664460%26ds_e_matchtype%3Dcontent%26ds_url_v%3D2http://googleads.g.doubleclick.net/aclk?sa=l&ai=BcWTie9Y9ULC8LsSNlALH_oC4CLTn-bEC1LKjzzDAjbcBsKiUARACGAIg2sX1AygDOABQjsi1z_z_____AWB1oAGe8_HuA7IBFHd3dy50ZWNocmVwdWJsaWMuY29tyAEB2gFWaHR0cDovL3d3dy50ZWNocmVwdWJsaWMuY29tL2Jsb2cvZGF0YWNlbnRlci9oZWxwLW15LXNxbC1zZXJ2ZXItbG9nLWZpbGUtaXMtdG9vLWJpZy80NDioAwHoA9cC9QMCAABE4Aa6_PwR&num=2&sig=AOD64_0FyQ38c1EZhvo03jtBJZfNvHPT2A&client=ca-cnet-techrepublic-content&adurl=http://clickserve.dartsearch.net/link/click%3Flid%3D43700003450913646%26ds_s_kwgid%3D58700000030950134%26ds_e_adid%3D12987664460%26ds_e_matchtype%3Dcontent%26ds_url_v%3D2http://googleads.g.doubleclick.net/aclk?sa=L&ai=BOOyee9Y9ULC8LsSNlALH_oC4CKy2w7QB_IagyQ3AjbcBoMpFEAMYAyDaxfUDKAM4AFC-lPu9-P____8BYHWyARR3d3cudGVjaHJlcHVibGljLmNvbcgBAdoBVmh0dHA6Ly93d3cudGVjaHJlcHVibGljLmNvbS9ibG9nL2RhdGFjZW50ZXIvaGVscC1teS1zcWwtc2VydmVyLWxvZy1maWxlLWlzLXRvby1iaWcvNDQ4gAIBqAMB6APXAvUDAgAAROAGpM_MAw&num=3&sig=AOD64_11hUpmWyUlLlVz-9DlD5JTA3GTmQ&client=ca-cnet-techrepublic-content&adurl=http://www.mavenwire.com/index.php%3Fpage%3Dsolutions-overviewhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BOOyee9Y9ULC8LsSNlALH_oC4CKy2w7QB_IagyQ3AjbcBoMpFEAMYAyDaxfUDKAM4AFC-lPu9-P____8BYHWyARR3d3cudGVjaHJlcHVibGljLmNvbcgBAdoBVmh0dHA6Ly93d3cudGVjaHJlcHVibGljLmNvbS9ibG9nL2RhdGFjZW50ZXIvaGVscC1teS1zcWwtc2VydmVyLWxvZy1maWxlLWlzLXRvby1iaWcvNDQ4gAIBqAMB6APXAvUDAgAAROAGpM_MAw&num=3&sig=AOD64_11hUpmWyUlLlVz-9DlD5JTA3GTmQ&client=ca-cnet-techrepublic-content&adurl=http://www.mavenwire.com/index.php%3Fpage%3Dsolutions-overviewhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BOOyee9Y9ULC8LsSNlALH_oC4CKy2w7QB_IagyQ3AjbcBoMpFEAMYAyDaxfUDKAM4AFC-lPu9-P____8BYHWyARR3d3cudGVjaHJlcHVibGljLmNvbcgBAdoBVmh0dHA6Ly93d3cudGVjaHJlcHVibGljLmNvbS9ibG9nL2RhdGFjZW50ZXIvaGVscC1teS1zcWwtc2VydmVyLWxvZy1maWxlLWlzLXRvby1iaWcvNDQ4gAIBqAMB6APXAvUDAgAAROAGpM_MAw&num=3&sig=AOD64_11hUpmWyUlLlVz-9DlD5JTA3GTmQ&client=ca-cnet-techrepublic-content&adurl=http://www.mavenwire.com/index.php%3Fpage%3Dsolutions-overviewhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BOOyee9Y9ULC8LsSNlALH_oC4CKy2w7QB_IagyQ3AjbcBoMpFEAMYAyDaxfUDKAM4AFC-lPu9-P____8BYHWyARR3d3cudGVjaHJlcHVibGljLmNvbcgBAdoBVmh0dHA6Ly93d3cudGVjaHJlcHVibGljLmNvbS9ibG9nL2RhdGFjZW50ZXIvaGVscC1teS1zcWwtc2VydmVyLWxvZy1maWxlLWlzLXRvby1iaWcvNDQ4gAIBqAMB6APXAvUDAgAAROAGpM_MAw&num=3&sig=AOD64_11hUpmWyUlLlVz-9DlD5JTA3GTmQ&client=ca-cnet-techrepublic-content&adurl=http://www.mavenwire.com/index.php%3Fpage%3Dsolutions-overviewhttp://cbsiprivacy.custhelp.com/app/answers/detail/a_id/1272/http://www.techrepublic.com/search?q=tim+chapmanhttp://www.techrepublic.com/blog/datacenter?mode=rsshttp://www.techrepublic.com/alerts/add?url=http%3A%2F%2Fwww.techrepublic.com%2Fblog%2Fdatacenter%3Fmode%3Drss&title=The+Enterprise+Cloud+on+TechRepublic&source=http%3A%2F%2Fwww.techrepublic.com%2Fblog%2Fdatacenter%2Fnew-date-datatypes-in-sql-server-2008%2F443&frequency=weekly&rss_type=38http://www.facebook.com/TechRepublichttp://twitter.com/techrepublichttps://plus.google.com/115467927011694256253/http://www.linkedin.com/groups?gid=38635http://digg.com/techrepublichttp://www.techrepublic.com/rssfeedshttps://market.android.com/details?id=com.lionbridge.android.techrepublichttp://www.techrepublic.com/members/login?regSrc=global-reghttp://www.techrepublic.com/members/join?regSrc=global-reghttp://www.techrepublic.com/faq/generalhttp://www.techrepublic.com/prohttp://www.zdnetasia.com/http://www.smartplanet.com/http://www.techrepublic.com/



Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublics freenewsletters.

View All

Ask a Question

View All

Media Gallery

DATETIME2This data type is very simiilar to the datetime data type present in previous versions of SQLServer. The difference is the time precision and the range of dates that DATETIME2 can store.The new DATETIME2 data type can hold a range of dates from 0001-01-01 through 9999-12-31while DATETIME holds the date range from 1753-01-01 to 9999-12-31. Another benefit of thisdata type is the precision in which it records time. DATETIME2 is accurate to within 100nanoseconds whereas DATETIME is accurate to within 3/1000 of a second. The following scriptcompares the values that the DATETIME and the DATETIME2 data-types can hold.

DECLARE @DateTime2 DATETIME2 = GETDATE()

DECLARE @DateTime DATETIME = GETDATE()

SELECT @DateTime, @DateTime2

Notice the additional precision stored in the DATETIME2 variable. This additional data can be ofmajor significance for those applications where time related information is mission-critical.

TIMEThe TIME data-type stores only the time portion of a date. This is significant in that the time datacan be stored seperately and not associated with a specific date. The TIME data-type, like theDATETIME2 data-type is accurate up to 100 nanoseconds. The following script compares the timespecific information returned by the TIME data type and that which is returned from a DATETIMEdata type.

DECLARE @Time TIME = GETDATE()

DECLARE @DateTime DATETIME = GETDATE()

SELECT @Time, @DateTime

DATETIMEOFFSETThe new DATETIMEOFFSET data type combines the range and precision of the DATETIME2data-type along with time-zone awareness based on a 24 hour clock. The time-zone awareness isaccomplished by adding or subtracting an hours + minutes value to the date data. In the followingexample, I define a temporary table that holds two fields. The first field holds the date that is localto my area. The second field, BeijingTime, is an offset date that will hold the time in Beijing, China;which happens to be 12 hours ahead of the time in Louisville, KY.

CREATE TABLE #OffSets

(

LouisvilleTime DATETIME2 DEFAULT(GETDATE()),

BeijingTime AS CONVERT(VARCHAR(50), LouisvilleTime, 121) + '+12:00'

)

INSERT INTO #OffSets(LouisvilleTime)

SELECT GETDATE()

SELECT * FROM #OffSets

As you can see from the results from the table, the BeijingTime field holds the date from theLouisvilleTime field along with a 12 hour offset to indicate Beijing time. This data-type greatlyenhances the ability to create time-zone aware applications.

TIME to try the new data-typesThe new date related data-types included in SQL Server 2008 greatly expand the databasedevelopers ability to not only store a wider range of dates and precision for those dates, but alsothe ability to zone time-zone specific data which can lead to more robust and accurate reporting oftime-related data around the world.

Hot Questions

Hot Discussions

More Galleries

More Videos

SSL redirection3

can anyone suggest if any suchsoftware exist with similarfunctionality?

2

Switching from a Job to a career inthe IT field: Need an IT pro'sadvice

3

windows 7 won't shutdown andkeeps switching on

2

Should developers be sued forsecurity holes?

221

The sitting duck that is opensource

79

Five fast Windows desktop searchutilities

27

Is the death knell sounding fortraditional antivirus?

30

PHOTO GALLERY (1 of 15)Curiosity's autonomous'seven minutes of...

VIDEO (1 of 13)Cracking Open: HTC Titan II

http://www.techrepublic.com/newslettershttp://www.techrepublic.com/newslettershttp://www.techrepublic.com/forum/questions/hothttp://www.techrepublic.com/forum/questions/posthttp://www.techrepublic.com/forum/questions/posthttp://www.techrepublic.com/forum/discussions/hothttp://www.facebook.com/TechRepublichttp://twitter.com/techrepublichttps://plus.google.com/115467927011694256253/http://www.linkedin.com/groups?gid=38635http://digg.com/techrepublichttp://www.techrepublic.com/rssfeedshttps://market.android.com/details?id=com.lionbridge.android.techrepublichttp://itunes.apple.com/us/app/techrepublic/id426493569http://www.techrepublic.com/photoshttp://www.techrepublic.com/photos/curiositys-autonomous-seven-minutes-of-terror-pictures/6377802http://www.techrepublic.com/videoshttp://www.techrepublic.com/videos/test/cracking-open-htc-titan-ii/6358899http://www.techrepublic.com/forum/questions/101-394302/ssl-redirectionhttp://www.techrepublic.com/forum/questions/101-394316/can-anyone-suggest-if-any-such-software-exist-with-similar-functionalityhttp://www.techrepublic.com/forum/questions/101-394316/can-anyone-suggest-if-any-such-software-exist-with-similar-functionalityhttp://www.techrepublic.com/forum/questions/101-394316/can-anyone-suggest-if-any-such-software-exist-with-similar-functionalityhttp://www.techrepublic.com/forum/questions/101-394290/switching-from-a-job-to-a-career-in-the-it-field-need-an-it-pros-advicehttp://www.techrepublic.com/forum/questions/101-394290/switching-from-a-job-to-a-career-in-the-it-field-need-an-it-pros-advicehttp://www.techrepublic.com/forum/questions/101-394290/switching-from-a-job-to-a-career-in-the-it-field-need-an-it-pros-advicehttp://www.techrepublic.com/forum/questions/101-394299/windows-7-wont-shutdown-and-keeps-switching-onhttp://www.techrepublic.com/forum/questions/101-394299/windows-7-wont-shutdown-and-keeps-switching-onhttp://www.techrepublic.com/forum/discussions/102-394196http://www.techrepublic.com/forum/discussions/102-394196http://www.techrepublic.com/forum/discussions/102-394277http://www.techrepublic.com/forum/discussions/102-394277http://www.techrepublic.com/forum/discussions/102-394303http://www.techrepublic.com/forum/discussions/102-394303http://www.techrepublic.com/forum/discussions/102-394285http://www.techrepublic.com/forum/discussions/102-394285http://www.techrepublic.com/photos/curiositys-autonomous-seven-minutes-of-terror-pictures/6377802http://www.techrepublic.com/videos/test/cracking-open-htc-titan-ii/6358899http://www.techrepublic.com/photos/curiositys-autonomous-seven-minutes-of-terror-pictures/6377802http://www.techrepublic.com/photos/curiositys-autonomous-seven-minutes-of-terror-pictures/6377802http://www.techrepublic.com/photos/curiositys-autonomous-seven-minutes-of-terror-pictures/6377802http://www.techrepublic.com/videos/test/cracking-open-htc-titan-ii/6358899http://www.techrepublic.com/videos/test/cracking-open-htc-titan-ii/6358899



5Comments

Add Your Opinion

See All CommentsMy Contacts

About Tim Chapman

Start a Discussion

Blog Archive

Join the conversation!

Full Bio Contact

Options for passing a driverinto the Windows Server2008 install program

Restarting Active Directoryas a service in WindowsServer 2008

People who read this...

No change in SQL Server 2008 pricing, says Microsoft

SQL server installation

SQL Server 2008 - How to uninstall or Delete unused Multiple Instances

10 tips for upgrading to SQL Server 2008 R2

Follow via:

Staff Picks Top Rated Most Recent

"Odd that it can go so far forward but not back far enough for some historical,geological, or anthropoligical data" Actually, I was kind of wondering about the abilityto go past 1753 with any... Read Whole Comment +

View in thread

Calendar issuesrwilson@... 24th Feb 2009

0Votes

View in thread

Exampleschapman.tim@... 10th Sep 2008

Sure, here are some examples:

DATE:2007-05-08

TIME:12:35:29. 1234567

DATETIME2:2007-05-08 12:35:29. 1234567

DATETIMEOFFSET:2007-05-08 12:35:29.1234567 +12:15

0Votes

August 2012

July 2012

June 2012

May 2012

April 2012

March 2012

February 2012

January 2012

December 2011

November 2011

October 2011

September 2011

August 2011

July 2011

June 2011

http://www.techrepublic.com/forum/discussions/102-273536http://www.techrepublic.com/forum/discussions/posthttp://www.techrepublic.com/forum/discussions/posthttp://www.techrepublic.com/blog/datacenter/options-for-passing-a-driver-into-the-windows-server-2008-install-program/439http://www.techrepublic.com/blog/datacenter/options-for-passing-a-driver-into-the-windows-server-2008-install-program/439http://www.techrepublic.com/blog/datacenter/options-for-passing-a-driver-into-the-windows-server-2008-install-program/439http://www.techrepublic.com/blog/datacenter/options-for-passing-a-driver-into-the-windows-server-2008-install-program/439http://www.techrepublic.com/blog/datacenter/restarting-active-directory-as-a-service-in-windows-server-2008/440http://www.techrepublic.com/blog/datacenter/restarting-active-directory-as-a-service-in-windows-server-2008/440http://www.techrepublic.com/blog/datacenter/restarting-active-directory-as-a-service-in-windows-server-2008/440http://www.techrepublic.com/blog/datacenter/restarting-active-directory-as-a-service-in-windows-server-2008/440http://www.techrepublic.com/blog/tech-news/no-change-in-sql-server-2008-pricing-says-microsoft/1263?tag=btxcsimhttp://www.techrepublic.com/forum/questions/101-322941?tag=btxcsimhttp://www.techrepublic.com/forum/questions/101-303138?tag=btxcsimhttp://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376?tag=btxcsimhttp://www.techrepublic.com/forum/discussions/102-273536/rsshttp://www.techrepublic.com/alerts/add?url=http%3A%2F%2Fwww.techrepublic.com%2Fforum%2Fdiscussions%2F102-273536%2Frss&title=Discussion+on+New+Date+Datatypes+in+SQL+Server+2008+on+TechRepublic&source=http%3A%2F%2Fwww.techrepublic.com%2Fblog%2Fdatacenter%2Fnew-date-datatypes-in-sql-server-2008%2F443&frequency=weekly&rss_type=42http://www.techrepublic.com/forum/discussions/102-273536-3022155http://www.techrepublic.com/members/profile/1998776http://www.techrepublic.com/util/votehttp://www.techrepublic.com/util/votehttp://www.techrepublic.com/forum/discussions/102-273536-2592344http://www.techrepublic.com/members/profile/4492495http://www.techrepublic.com/util/votehttp://www.techrepublic.com/util/votehttp://www.techrepublic.com/util/votehttp://www.techrepublic.com/blog/datacenter/201208http://www.techrepublic.com/blog/datacenter/201207http://www.techrepublic.com/blog/datacenter/201206http://www.techrepublic.com/blog/datacenter/201205http://www.techrepublic.com/blog/datacenter/201204http://www.techrepublic.com/blog/datacenter/201203http://www.techrepublic.com/blog/datacenter/201202http://www.techrepublic.com/blog/datacenter/201201http://www.techrepublic.com/blog/datacenter/201112http://www.techrepublic.com/blog/datacenter/201111http://www.techrepublic.com/blog/datacenter/201110http://www.techrepublic.com/blog/datacenter/201109http://www.techrepublic.com/blog/datacenter/201108http://www.techrepublic.com/blog/datacenter/201107http://www.techrepublic.com/blog/datacenter/201106



Join Login

See all comments

Join the TechRepublic Community and join the conversation! Signing-up isfree and quick, Do it now, we want to hear your opinion.

Its about time we get a DATE type! I always tested date ranges like this: SELECT *FROM SalesHistory WHERE SaleDate Between @SaleDate AND @SaleDate + '11:59 pm' Of course @SaleDate was formatted... Read Whole Comment +

View in thread

RE: New Date Datatypes in SQL Server 2008dwarsham@... 10th Sep 2008

0Votes

http://www.techrepublic.com/forum/discussions/102-273536http://www.techrepublic.com/members/join?regSrc=disc-starthttp://www.techrepublic.com/members/join?regSrc=disc-starthttp://www.techrepublic.com/members/login?regSrc=disc-starthttp://www.techrepublic.com/members/login?regSrc=disc-starthttp://www.techrepublic.com/forum/discussions/102-273536http://www.techrepublic.com/forum/discussions/102-273536-2592045http://www.techrepublic.com/members/profile/4122061http://www.techrepublic.com/util/votehttp://www.techrepublic.com/util/vote

techrepublic.comNew Date Datatypes in SQL Server 2008 | TechRepublic

4tc3FsLXNlcnZlci0yMDA4LzQ0MwA=: form1: email: newsletters: e059:INTERNAL_NEWSLETTERnewsletters_(1): e062:INTERNAL_NEWSLETTERbutton0: q: button3:

new date datatypes in sql server 2008 tech republic

Documents