Hi,

I have a class with a property of DateTime type. in my MSSQL, the column type is also DateTime. Everything worked fine until I try to order by that property. It only store the date, not the time (says 12:00:00 for every entry).

when I check my property in the debugger, it says the correct date AND time but not in the DB. Any idea?

Here is my mapping doc:
<class name="Com.Progmatik.OSWeblog.BlogContent, Com.Progmatik.OSWeblog.ObjectsModel" table="BlogContent" discriminator-value="BlogContent">
<id name="IdBlogContent" unsaved-value="0" access="nosetter.camelcase-underscore">
<generator class="native" />
</id>
<discriminator column="SubClass" type="String" />
<!--<version name="Version" column="Version" unsaved-value="0" />-->
<property name="Content" column="BlogContent" />
<property name="DatePosted" />
<property name="Title" />
</class>
</hibernate-mapping>



Here is my class:

public class BlogContent
{
private DateTime _datePosted;

public DateTime DatePosted
{
get { return this._datePosted; }
set { this._datePosted = value; }
}
}


Thanks for your help.

Try forcing the underlying table type in your entity map:

<property name="DatePosted" type="timestamp"/>

See 1.2.2 The Mapping File. If you scroll down to the third paragraph after the fourth code block, you'll see this:



In your class you're using DateTime (and a totally different language and platform :), but I suspect it's the same issue.

Hi there,

Thanks for the quick reply!

I tried it and still the same. Actually, I tried with the property type="timestamp", "date" and "time" and I still get 12:00:00 AM in all cases.

what else could it be?

Thank you

I'm using "DateTime" (or "System.DateTime") and works fine.

Geez! My Fault!!!

on one place, I had myObject.DatePosted = DateTime.Now;

and somewhere else,

I had myObject.DatePosted = new DateTime((int)2005, (int)05, (int)05);
which would set the time to 12:00:00AM !!

Can't believe I lost 10h on this!!!

Thanks anyways