Guest User

Untitled

a guest
May 26th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. DateTime d = new DateTime(40010); //invalid
  2.  
  3. DateTime myDate = new DateTime(1900, 1, 1).AddDays(days);
  4.  
  5. private DateTime AS400 = new DateTime(1900, 1, 1);
  6.  
  7. ...
  8.  
  9.  
  10. DateTime myClrDT = AS400.AddDays(days);
  11.  
  12. DateTime d = Convert.ToDateTime(reader["DateField"]);
  13.  
  14. SELECT
  15. CAST(0 AS datetime) AS dateTimeZero,
  16. CAST(0 AS smalldatetime) AS smallDateTimeZero
  17.  
  18. dateTimeZero smallDateTimeZero
  19. ======================= ===================
  20. 1900-01-01 00:00:00.000 1900-01-01 00:00:00
  21.  
  22. select date(15+719892) as date1 from library1.file1
Add Comment
Please, Sign In to add comment