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 7.1301 2017-05-15 00:00:00.0 7.1301 233
2 13.0888 2017-05-16 00:00:00.0 5.9587 233
3 13.0888 2017-05-17 00:00:00.0 0.0000 233
4 13.0888 2017-05-18 00:00:00.0 0.0000 233
5 15.9847 2017-05-19 00:00:00.0 2.8959 233
6 21.8520 2017-05-20 00:00:00.0 5.8673 233
7 24.6270 2017-05-21 00:00:00.0 2.7750 233
8 29.8265 2017-05-22 00:00:00.0 5.1995 233
9 36.5612 2017-05-23 00:00:00.0 6.7347 233
10 43.9893 2017-05-24 00:00:00.0 7.4281 233
11 49.8566 2017-05-25 00:00:00.0 5.8673 233
12 55.2520 2017-05-26 00:00:00.0 5.3954 233
13 61.3010 2017-05-27 00:00:00.0 6.0490 233
14 65.9928 2017-05-28 00:00:00.0 4.6918 233
15 69.1275 2017-05-29 00:00:00.0 3.1347 233
16 74.7147 2017-05-30 00:00:00.0 5.5872 233
17 83.3351 2017-05-31 00:00:00.0 8.6204 233
18 91.8228 2017-06-01 00:00:00.0 8.4877 233
19 101.4228 2017-06-02 00:00:00.0 9.6000 233
20 111.3228 2017-06-03 00:00:00.0 9.9000 233
21 120.8004 2017-06-04 00:00:00.0 9.4776 233
22 130.7269 2017-06-05 00:00:00.0 9.9265 233
23 139.9106 2017-06-06 00:00:00.0 9.1837 233
24 148.9672 2017-06-07 00:00:00.0 9.0566 233
25 158.7203 2017-06-08 00:00:00.0 9.7531 233
26 167.3407 2017-06-09 00:00:00.0 8.6204 233
27 176.5647 2017-06-10 00:00:00.0 9.2240 233
28 185.1315 2017-06-11 00:00:00.0 8.5668 233
29 193.2330 2017-06-12 00:00:00.0 8.1015 233
30 201.1432 2017-06-13 00:00:00.0 7.9102 233
31 208.7840 2017-06-14 00:00:00.0 7.6408 233
32 215.8371 2017-06-15 00:00:00.0 7.0531 233
33 223.4080 2017-06-16 00:00:00.0 7.5709 233
34 229.9774 2017-06-17 00:00:00.0 6.5694 233
35 236.3774 2017-06-18 00:00:00.0 6.4000 233
36 243.2733 2017-06-19 00:00:00.0 6.8959 233
37 250.9830 2017-06-20 00:00:00.0 7.7097 233
38 259.4396 2017-06-21 00:00:00.0 8.4566 233
39 266.6457 2017-06-22 00:00:00.0 7.2061 233
40 271.3375 2017-06-23 00:00:00.0 4.6918 233
41 274.5901 2017-06-24 00:00:00.0 3.2526 233
42 279.8881 2017-06-25 00:00:00.0 5.2980 233
43 287.6657 2017-06-26 00:00:00.0 7.7776 233
44 297.1101 2017-06-27 00:00:00.0 9.4444 233
45 306.8162 2017-06-28 00:00:00.0 9.7061 233
46 315.4892 2017-06-29 00:00:00.0 8.6730 233
47 323.3336 2017-06-30 00:00:00.0 7.8444 233
48 331.6759 2017-07-01 00:00:00.0 8.3423 233
49 339.8999 2017-07-02 00:00:00.0 8.2240 233
50 349.8382 2017-07-03 00:00:00.0 9.9383 233
51 359.8370 2017-07-04 00:00:00.0 9.9988 233
52 369.7135 2017-07-05 00:00:00.0 9.8765 233
53 379.7007 2017-07-06 00:00:00.0 9.9872 233
54 389.3558 2017-07-07 00:00:00.0 9.6551 233
55 399.3553 2017-07-08 00:00:00.0 9.9995 233
56 409.3140 2017-07-09 00:00:00.0 9.9587 233
57 419.3135 2017-07-10 00:00:00.0 9.9995 233
58 428.6150 2017-07-11 00:00:00.0 9.3015 233
59 437.5354 2017-07-12 00:00:00.0 8.9204 233
60 446.7191 2017-07-13 00:00:00.0 9.1837 233
61 456.5885 2017-07-14 00:00:00.0 9.8694 233
62 466.4737 2017-07-15 00:00:00.0 9.8852 233
63 476.3431 2017-07-16 00:00:00.0 9.8694 233
64 486.2569 2017-07-17 00:00:00.0 9.9138 233
65 494.7135 2017-07-18 00:00:00.0 8.4566 233
66 503.8558 2017-07-19 00:00:00.0 9.1423 233
67 513.3002 2017-07-20 00:00:00.0 9.4444 233
68 523.0303 2017-07-21 00:00:00.0 9.7301 233
69 532.2936 2017-07-22 00:00:00.0 9.2633 233
70 542.0467 2017-07-23 00:00:00.0 9.7531 233
71 552.0269 2017-07-24 00:00:00.0 9.9802 233
72 561.3657 2017-07-25 00:00:00.0 9.3388 233
73 571.2657 2017-07-26 00:00:00.0 9.9000 233
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '233') 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 571
7/25/2017 9 561
7/24/2017 10 552
7/23/2017 10 542
7/22/2017 9 532
7/21/2017 10 523
7/20/2017 9 513
7/19/2017 9 504
7/18/2017 8 495
7/17/2017 10 486
7/16/2017 10 476
7/15/2017 10 466
7/14/2017 10 457
7/13/2017 9 447
7/12/2017 9 438
7/11/2017 9 429
7/10/2017 10 419
7/9/2017 10 409
7/8/2017 10 399
7/7/2017 10 389
7/6/2017 10 380
7/5/2017 10 370
7/4/2017 10 360
7/3/2017 10 350
7/2/2017 8 340
7/1/2017 8 332
6/30/2017 8 323
6/29/2017 9 315
6/28/2017 10 307
6/27/2017 9 297
6/26/2017 8 288
6/25/2017 5 280
6/24/2017 3 275
6/23/2017 5 271
6/22/2017 7 267
6/21/2017 8 259
6/20/2017 8 251
6/19/2017 7 243
6/18/2017 6 236
6/17/2017 7 230
6/16/2017 8 223
6/15/2017 7 216
6/14/2017 8 209
6/13/2017 8 201
6/12/2017 8 193
6/11/2017 9 185
6/10/2017 9 177
6/9/2017 9 167
6/8/2017 10 159
6/7/2017 9 149
6/6/2017 9 140
6/5/2017 10 131
6/4/2017 9 121
6/3/2017 10 111
6/2/2017 10 101
6/1/2017 8 92
5/31/2017 9 83
5/30/2017 6 75
5/29/2017 3 69
5/28/2017 5 66
5/27/2017 6 61
5/26/2017 5 55
5/25/2017 6 50
5/24/2017 7 44
5/23/2017 7 37
5/22/2017 5 30
5/21/2017 3 25
5/20/2017 6 22
5/19/2017 3 16
5/18/2017 0 13
5/17/2017 0 13
5/16/2017 6 13
5/15/2017 7 7