[2.0] server date

oolon · **Posted:** Wed Sep 17, 2008 12:55 pm

Hello,

I Just want to recover the server date.

If I do a query like that :

Code:

return sess.CreateQuery("select current from User")
                    .SetMaxResults(1)
                    .List<DateTime>()[0];

It doesn't work.

So what the solution please?

Thank you in advance

wolli · **Posted:** Thu Sep 18, 2008 3:46 am

You have to post a bit more information if you want help. At least the error message you get, check the inner exception. Parts of the mapping.

oolon · **Posted:** Thu Sep 18, 2008 8:39 am

Sorry I just wanted to know if it's possible to recover the server date with a NHibernate behavior

Finally I create it my slef :

I created a View

Code:

create view "informix".date_system_view (today) as select TODAY
from "informix".systables x0 where (x0.tabid = 1 )

and I Created my object just for the date :

Code:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" default-access="property" default-lazy="true">
  <class name=".......DomainModel.DateSystemView, DomainModel" table="date_system_view" batch-size="30" >
    <id name="Today" type="DateTime" column="today" unsaved-value="none">
      <generator class="assigned" />
    </id>
  </class>
</hibernate-mapping>

So When I want to know the server date I just have to write :

Code:

((DateSystemView)sess.CreateQuery("from DateSystemView").UniqueResult()).Today;

I'm sure it's possible easier but I don't know how

wolli · **Posted:** Thu Sep 18, 2008 8:47 am

You can use a SQLQuery for this.

Code:

DateTime today = session.CreateSQLQuery("select today from informix.systables x0 where x0.tabid = 1")
   .AddScalar("today ", NHibernateUtil.Date)
   .UniqueResult<DateTime>

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html#querysql-creating