Internal storage of DateTime and SmallDateTime.
i using sql server 2005 express. few columns in table of datetime datatype , few smalldatetime. windows xp regional settings set date format dd/mm/yyyy.
from web form, entering dates in format dd/mm/yyyy format. when see records management studio, records of datetime column stored in yyyy-mm-dd format, whereas records of smalldatetime column stored in dd/mm/yyyy format.
why difference? how both data types internally managed , how can make dd/mm/yyyy format default installation?
this tell need know datetime in sql server. suggest start here , post if have question after reading:
http://www.karaszi.com/sqlserver/info_datetime.asp
tibor karaszi, sql server mvp | web | blog
SQL Server > Getting started with SQL Server
Comments
Post a Comment