title: NHibernate: storing / retrieving dates in / from Sqlite
body: <p>I have this simple object </p>
  
  <pre><code>public class SomeObject
  {
      public virtual DateTime TimeStamp { get; }
  }
  </code></pre>
  
  <p>I would like to know how to map a DateTime property sqlite using nhibernate,</p>
  
  <p>Tried something like this </p>
  
  <pre><code> mapping.Map(Reveal.Member&lt;Something&gt;("TimeStamp"))
              .Default(DateTime.UtcNow.Second.ToString())
              .Generated.Insert()
              .Not.Nullable();
  </code></pre>
  
  <p>When trying to do an insert </p>
  
  <pre><code>            session.Save(new SomeObject());
              tran.Commit();
  </code></pre>
  
  <p>I get this </p>
  
  <blockquote>
    <p>Input string '29' was not in the correct format.'
    InvalidCastException: Invalid cast from 'Int32' to 'DateTime'.</p>
  </blockquote>