difference between datetime & smalldatetime ...

Replies

Sakthi.Singaravel
Posted on: 4/17/2012 6:59:44 AM

Level: Silver | Status: [Member] | Points: 25

See this Microsoft reference with example...

http://msdn.microsoft.com/en-us/library/aa258277(v=sql.80).aspx

Regards,
Singaravel M

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Sunny4989
Posted on: 4/17/2012 7:02:58 AM

Level: Starter | Status: [Member] | Points: 25

Range

SmallDateTime: 1 - jan - 1900 to 6 - jun - 2079
DateTime : 1 - jan -1753 to 31 - Dec - 9999

Precision

SmallDateTime: Minute
DateTime : Three hundredth of a second(3.33)

Storage

SmallDateTime: 4 Bytes
DateTime : 8 bytes

------------------------------------------------
Learn throughout life

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Sridevi
Posted on: 4/17/2012 7:07:19 AM

Level: Starter | Status: [Member] | Points: 25

Hi Sandeep,

Could you please clarify about the range?

Do u mean that we have to give only in between values which u have mentioned?

Regards,
Sridevi

Sridevi

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Sunny4989
Posted on: 4/17/2012 7:28:37 AM

Level: Starter | Status: [Member] | Points: 25

Hi sridevi

It's not sandeep it's sunil or sunny

Yes!!! you are correct .

------------------------------------------------
Learn throughout life

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Sridevi
Posted on: 4/17/2012 9:09:13 AM

Level: Starter | Status: [Member] | Points: 25

Ok Sunil. Sorry for the mistake and Thanks

Sridevi

Sridevi

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Muhsinathk
Posted on: 6/19/2012 7:48:05 AM

Level: Bronze | Status: [Member] | Points: 25

Refer this link

http://msdn.microsoft.com/en-us/library/aa258277(v=sql.80).aspx

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

CGN007
Posted on: 6/20/2012 4:39:43 AM

Level: Silver | Status: [Member] | Points: 25

Please refer this SQL Server date vs smalldatetime http://stackoverflow.com/questions/5622158/sql-server-date-vs-smalldatetime

Also have look at this http://blog.sqlauthority.com/2010/06/01/sql-server-precision-of-smalldatetime-a-1-minute-precision/

Sandeepkasar, if this helps please login to Mark As Answer. | Reply | Alert Moderator

difference between datetime & smalldatetime

Replies

Reply - Please login to reply

Latest Posts