Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. (1,1,'07-04-2014','08-04-2014'),
  2. (2,2,'07-04-2014','07-04-2014'),
  3. (3,3,'08-04-2014','10-04-2014'),
  4. (4,4,'09-04-2014','10-04-2014')
  5.  
  6. SELECT AVG(DATEDIFF(DD,'19700101',dateField)) AS avgDays
  7.  
  8. SELECT DATEDIFF(MINUTE, '1901-1-1', patientEntryDate)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement