Replacement of DateTime.MinValue in C# to sql

Question

In C#, I have using linq ,in which i consumed DateTime of Min value. I am going to convert this query in oracle.

select x 
from x in Context.GetRolePlansQuery(AppResources.CurrentUser.Role.RoleId,
                                                                   AppResources.CurrentUser.Loginid,
                                                                   AppResources.CurrentUser.Tpa.TpaId) where
x.LAST_STAGE_COMPLETE.ToUpper() == "RECEIVED"
orderby (x.CDC_COMPLETE_DATE.HasValue ? x.CDC_COMPLETE_DATE : DateTime.MinValue) descending
select x

I want to know the server datetime of Min value in oracle.

http://stackoverflow.com/a/687533/342740 – Prix Jun 06 '13 at 07:03 — Prix, Jun 06 '13 at 07:03

score 1 · Answer 1 · answered Jun 06 '13 at 07:13

This should give you a fair understanding of the range of values of oracle sql server data types: http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm#i54330

However, there is a difference in the min value of the .net object and the sql server data type, the min value of DateTime.MinValue is 0001/1/1.

Replacement of DateTime.MinValue in C# to sql

1 Answers1