Since we generat Reports from DB2 used by JDE, we need to convert Gregorian date to julian date when we write SQL queries... searched a lot for this option on web. Thought this should be helpful to lot of people who is looking for it...
int intJulianDate = 1000 * (DateTime.Now.Year - 1900) + DateTime.Now.DayOfYear;
Console.WriteLine(intJulianDate.ToString());
Hope it helpzFauzi - 4Z
1 comment:
works like magic, thx very much
Post a Comment