title: When storing a datetime in sql server (datetime type), what format does it store it in?
body: <p>When storing a datetime value in sql server 2008, using the datetime type, what format will it store the value in?</p>
  
  <p>Is it the number of seconds since 1970 (or whatever)?</p>
  
  <p>On the application side (.net), I am passing in a datetime object.</p>
  
  <p>When I view the table's rows in query analyzer, will it format it according to my culture settings or am I viewing exactly what is stored in the db?</p>