Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne Gladstone Portage East High Bluff Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Macdonald Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 8.4566 2017-05-15 00:00:00.0 8.4566 201
2 15.2724 2017-05-16 00:00:00.0 6.8158 201
3 15.2724 2017-05-17 00:00:00.0 0.0000 201
4 15.2724 2017-05-18 00:00:00.0 0.0000 201
5 18.1683 2017-05-19 00:00:00.0 2.8959 201
6 24.3066 2017-05-20 00:00:00.0 6.1383 201
7 26.2066 2017-05-21 00:00:00.0 1.9000 201
8 30.5816 2017-05-22 00:00:00.0 4.3750 201
9 37.7877 2017-05-23 00:00:00.0 7.2061 201
10 45.8892 2017-05-24 00:00:00.0 8.1015 201
11 53.4601 2017-05-25 00:00:00.0 7.5709 201
12 61.2377 2017-05-26 00:00:00.0 7.7776 201
13 69.5214 2017-05-27 00:00:00.0 8.2837 201
14 74.2132 2017-05-28 00:00:00.0 4.6918 201
15 76.3683 2017-05-29 00:00:00.0 2.1551 201
16 82.1433 2017-05-30 00:00:00.0 5.7750 201
17 90.8163 2017-05-31 00:00:00.0 8.6730 201
18 100.8114 2017-06-01 00:00:00.0 9.9951 201
19 109.1213 2017-06-02 00:00:00.0 8.3099 201
20 119.0769 2017-06-03 00:00:00.0 9.9556 201
21 128.6769 2017-06-04 00:00:00.0 9.6000 201
22 138.6720 2017-06-05 00:00:00.0 9.9951 201
23 148.6720 2017-06-06 00:00:00.0 10.0000 201
24 157.7720 2017-06-07 00:00:00.0 9.1000 201
25 167.6414 2017-06-08 00:00:00.0 9.8694 201
26 177.4373 2017-06-09 00:00:00.0 9.7959 201
27 187.1674 2017-06-10 00:00:00.0 9.7301 201
28 196.9205 2017-06-11 00:00:00.0 9.7531 201
29 205.8409 2017-06-12 00:00:00.0 8.9204 201
30 214.5654 2017-06-13 00:00:00.0 8.7245 201
31 223.3899 2017-06-14 00:00:00.0 8.8245 201
32 231.4914 2017-06-15 00:00:00.0 8.1015 201
33 239.9480 2017-06-16 00:00:00.0 8.4566 201
34 247.1541 2017-06-17 00:00:00.0 7.2061 201
35 253.9699 2017-06-18 00:00:00.0 6.8158 201
36 261.5408 2017-06-19 00:00:00.0 7.5709 201
37 269.4510 2017-06-20 00:00:00.0 7.9102 201
38 278.3240 2017-06-21 00:00:00.0 8.8730 201
39 286.7806 2017-06-22 00:00:00.0 8.4566 201
40 293.0944 2017-06-23 00:00:00.0 6.3138 201
41 296.5796 2017-06-24 00:00:00.0 3.4852 201
42 302.0714 2017-06-25 00:00:00.0 5.4918 201
43 310.2954 2017-06-26 00:00:00.0 8.2240 201
44 320.1954 2017-06-27 00:00:00.0 9.9000 201
45 330.1770 2017-06-28 00:00:00.0 9.9816 201
46 339.4010 2017-06-29 00:00:00.0 9.2240 201
47 347.8010 2017-06-30 00:00:00.0 8.4000 201
48 356.3678 2017-07-01 00:00:00.0 8.5668 201
49 364.5918 2017-07-02 00:00:00.0 8.2240 201
50 374.5898 2017-07-03 00:00:00.0 9.9980 201
51 383.9923 2017-07-04 00:00:00.0 9.4025 201
52 393.8688 2017-07-05 00:00:00.0 9.8765 201
53 403.8676 2017-07-06 00:00:00.0 9.9988 201
54 413.5977 2017-07-07 00:00:00.0 9.7301 201
55 423.5866 2017-07-08 00:00:00.0 9.9889 201
56 433.5738 2017-07-09 00:00:00.0 9.9872 201
57 443.5689 2017-07-10 00:00:00.0 9.9951 201
58 453.4036 2017-07-11 00:00:00.0 9.8347 201
59 461.7459 2017-07-12 00:00:00.0 8.3423 201
60 470.4704 2017-07-13 00:00:00.0 8.7245 201
61 480.4520 2017-07-14 00:00:00.0 9.9816 201
62 490.3214 2017-07-15 00:00:00.0 9.8694 201
63 500.2479 2017-07-16 00:00:00.0 9.9265 201
64 510.0059 2017-07-17 00:00:00.0 9.7580 201
65 519.3074 2017-07-18 00:00:00.0 9.3015 201
66 528.6462 2017-07-19 00:00:00.0 9.3388 201
67 538.2743 2017-07-20 00:00:00.0 9.6281 201
68 548.1743 2017-07-21 00:00:00.0 9.9000 201
69 557.5493 2017-07-22 00:00:00.0 9.3750 201
70 567.2794 2017-07-23 00:00:00.0 9.7301 201
71 577.0708 2017-07-24 00:00:00.0 9.7914 201
72 586.9846 2017-07-25 00:00:00.0 9.9138 201
73 596.9596 2017-07-26 00:00:00.0 9.9750 201
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '201') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/26/2017 10 597
7/25/2017 10 587
7/24/2017 10 577
7/23/2017 10 567
7/22/2017 9 558
7/21/2017 10 548
7/20/2017 10 538
7/19/2017 9 529
7/18/2017 9 519
7/17/2017 10 510
7/16/2017 10 500
7/15/2017 10 490
7/14/2017 10 480
7/13/2017 9 470
7/12/2017 8 462
7/11/2017 10 453
7/10/2017 10 444
7/9/2017 10 434
7/8/2017 10 424
7/7/2017 10 414
7/6/2017 10 404
7/5/2017 10 394
7/4/2017 9 384
7/3/2017 10 375
7/2/2017 8 365
7/1/2017 9 356
6/30/2017 8 348
6/29/2017 9 339
6/28/2017 10 330
6/27/2017 10 320
6/26/2017 8 310
6/25/2017 5 302
6/24/2017 3 297
6/23/2017 6 293
6/22/2017 8 287
6/21/2017 9 278
6/20/2017 8 269
6/19/2017 8 262
6/18/2017 7 254
6/17/2017 7 247
6/16/2017 8 240
6/15/2017 8 231
6/14/2017 9 223
6/13/2017 9 215
6/12/2017 9 206
6/11/2017 10 197
6/10/2017 10 187
6/9/2017 10 177
6/8/2017 10 168
6/7/2017 9 158
6/6/2017 10 149
6/5/2017 10 139
6/4/2017 10 129
6/3/2017 10 119
6/2/2017 8 109
6/1/2017 10 101
5/31/2017 9 91
5/30/2017 6 82
5/29/2017 2 76
5/28/2017 5 74
5/27/2017 8 70
5/26/2017 8 61
5/25/2017 8 53
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 4 31
5/21/2017 2 26
5/20/2017 6 24
5/19/2017 3 18
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8