Question: I have shifted our live server to a new server configuration Windows 2008 server and sql server 2008.

But I am having following exception while adding date field data :

> 
> 2011-05-15 18:00:44,263 ERROR Error
>  caught : the details of the error are 
>  System.Data.SqlTypes.SqlTypeException:
>  SqlDateTime overflow. Must be between
>  1/1/1753 12:00:00 AM and 12/31/9999
>  11:59:59 PM. at
>  System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan
>  value)
> 
> 
> 

But the same code is working fine on local machine and was also working fine on old server.

I have even changed the date field explicitly into **"mm/dd/yy"** format.
But still not found the solution.
Can anyone provide me the solution.

Answer: 
Website:

* Possible to maintain a separate customer base for the website, or can
share the customer accounts with all websites
* Different base currency can be defined
* Different order base can be maintained (Need citation on this one)
* Different prices can be given for the website using a configuration
setting or can share the price globally
* Different Website URLs can be used or can share the same website URL
(Magento keeps unique cookies)

Store:

* Customer accounts are shared among all the stores under a specific
website
* Same base currency
* Same Price
* Product can be assigned store specifically
* Can have different root category configuration

Store View:

* Common practice is to distinguish between different language views
for store
* Different display prices
* Category settings can be different
* Same root category for all store views

**Inventory is global across all the websites and stores.** Either the product is IN STOCK or not! If need different inventories, have to use third party modules

Hope this helps....
Here is what I found on Magento site which helped me to clear the difference between the 3 notions. 

**Website** is a parent of store (or a basis for a store). It can consist of one or several stores. 

**Store** is a "child of website". You create and manage products and categories on this level. 
Store (or store view group): Stores are ‘children’ of websites. Products and Categories are managed on the store level. A root category is configured for each store. 

To be browsable in the interface a store requires one or more **store views**. The catalog structure per store view will always be the same. It allows multiple store presentations in the front end (like the opportunity to switch between 2 or more languages)