Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler Kane Brunkild Austin Bagot Elie Kenton Neepawa St. Claude


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 4.7508 2022-06-06 00:00:00.0 4.7508 550
2 10.9404 2022-06-07 00:00:00.0 6.1896 550
3 18.3653 2022-06-08 00:00:00.0 7.4249 550
4 25.4745 2022-06-09 00:00:00.0 7.1092 550
5 33.7281 2022-06-10 00:00:00.0 8.2536 550
6 42.2190 2022-06-11 00:00:00.0 8.4909 550
7 51.3150 2022-06-12 00:00:00.0 9.0960 550
8 59.9554 2022-06-13 00:00:00.0 8.6404 550
9 67.4026 2022-06-14 00:00:00.0 7.4472 550
10 73.0859 2022-06-15 00:00:00.0 5.6833 550
11 80.8708 2022-06-16 00:00:00.0 7.7849 550
12 89.4088 2022-06-17 00:00:00.0 8.5380 550
13 96.9262 2022-06-18 00:00:00.0 7.5174 550
14 102.7845 2022-06-19 00:00:00.0 5.8583 550
15 112.4673 2022-06-20 00:00:00.0 9.6828 550
16 121.4203 2022-06-21 00:00:00.0 8.9530 550
17 129.3522 2022-06-22 00:00:00.0 7.9319 550
18 137.3550 2022-06-23 00:00:00.0 8.0028 550
19 146.3914 2022-06-24 00:00:00.0 9.0364 550
20 152.5838 2022-06-25 00:00:00.0 6.1924 550
21 159.9713 2022-06-26 00:00:00.0 7.3875 550
22 167.6317 2022-06-27 00:00:00.0 7.6604 550
23 175.4022 2022-06-28 00:00:00.0 7.7705 550
24 183.8296 2022-06-29 00:00:00.0 8.4274 550
25 191.7589 2022-06-30 00:00:00.0 7.9293 550
26 197.9597 2022-07-01 00:00:00.0 6.2008 550
27 205.3216 2022-07-02 00:00:00.0 7.3619 550
28 214.0621 2022-07-03 00:00:00.0 8.7405 550
29 223.2449 2022-07-04 00:00:00.0 9.1828 550
30 232.2890 2022-07-05 00:00:00.0 9.0441 550
31 241.3427 2022-07-06 00:00:00.0 9.0537 550
32 250.0842 2022-07-07 00:00:00.0 8.7415 550
33 258.3295 2022-07-08 00:00:00.0 8.2453 550
34 267.0601 2022-07-09 00:00:00.0 8.7306 550
35 276.2040 2022-07-10 00:00:00.0 9.1439 550
36 285.3245 2022-07-11 00:00:00.0 9.1205 550
37 294.0630 2022-07-12 00:00:00.0 8.7385 550
38 302.5830 2022-07-13 00:00:00.0 8.5200 550
39 311.8439 2022-07-14 00:00:00.0 9.2609 550
40 320.2362 2022-07-15 00:00:00.0 8.3923 550
41 328.7705 2022-07-16 00:00:00.0 8.5343 550
42 335.6989 2022-07-17 00:00:00.0 6.9284 550
43 344.4442 2022-07-18 00:00:00.0 8.7453 550
44 354.0586 2022-07-19 00:00:00.0 9.6144 550
45 362.9965 2022-07-20 00:00:00.0 8.9379 550
46 371.1455 2022-07-21 00:00:00.0 8.1490 550
47 379.4590 2022-07-22 00:00:00.0 8.3135 550
48 387.8269 2022-07-23 00:00:00.0 8.3679 550
49 394.7424 2022-07-24 00:00:00.0 6.9155 550
50 402.6943 2022-07-25 00:00:00.0 7.9519 550
51 411.1595 2022-07-26 00:00:00.0 8.4652 550
52 418.4616 2022-07-27 00:00:00.0 7.3021 550
53 426.2900 2022-07-28 00:00:00.0 7.8284 550
54 433.6654 2022-07-29 00:00:00.0 7.3754 550
55 441.3218 2022-07-30 00:00:00.0 7.6564 550
56 450.2916 2022-07-31 00:00:00.0 8.9698 550
57 458.8067 2022-08-01 00:00:00.0 8.5151 550
58 467.3204 2022-08-02 00:00:00.0 8.5137 550
59 475.7599 2022-08-03 00:00:00.0 8.4395 550
60 483.8110 2022-08-04 00:00:00.0 8.0511 550
61 492.7940 2022-08-05 00:00:00.0 8.9830 550
62 499.7006 2022-08-06 00:00:00.0 6.9066 550
63 506.0269 2022-08-07 00:00:00.0 6.3263 550
64 513.6210 2022-08-08 00:00:00.0 7.5941 550
65 521.8290 2022-08-09 00:00:00.0 8.2080 550
66 529.4122 2022-08-10 00:00:00.0 7.5832 550
67 537.1598 2022-08-11 00:00:00.0 7.7476 550
68 546.3499 2022-08-12 00:00:00.0 9.1901 550
69 555.0980 2022-08-13 00:00:00.0 8.7481 550
70 563.8886 2022-08-14 00:00:00.0 8.7906 550
71 573.0943 2022-08-15 00:00:00.0 9.2057 550
72 581.5091 2022-08-16 00:00:00.0 8.4148 550
73 590.5142 2022-08-17 00:00:00.0 9.0051 550
74 599.6911 2022-08-18 00:00:00.0 9.1769 550
75 608.9391 2022-08-19 00:00:00.0 9.2480 550
76 616.7637 2022-08-20 00:00:00.0 7.8246 550
77 624.4170 2022-08-21 00:00:00.0 7.6533 550
78 633.6208 2022-08-22 00:00:00.0 9.2038 550
79 642.9576 2022-08-23 00:00:00.0 9.3368 550
80 650.8211 2022-08-24 00:00:00.0 7.8635 550
81 657.9531 2022-08-25 00:00:00.0 7.1320 550
82 666.0887 2022-08-26 00:00:00.0 8.1356 550
83 674.0981 2022-08-27 00:00:00.0 8.0094 550
84 682.8295 2022-08-28 00:00:00.0 8.7314 550
85 690.9620 2022-08-29 00:00:00.0 8.1325 550
86 697.8414 2022-08-30 00:00:00.0 6.8794 550
87 704.6637 2022-08-31 00:00:00.0 6.8223 550
88 711.5506 2022-09-01 00:00:00.0 6.8869 550
89 719.3654 2022-09-02 00:00:00.0 7.8148 550
90 726.8063 2022-09-03 00:00:00.0 7.4409 550
91 734.4664 2022-09-04 00:00:00.0 7.6601 550
92 743.2372 2022-09-05 00:00:00.0 8.7708 550
93 751.3273 2022-09-06 00:00:00.0 8.0901 550
94 758.0622 2022-09-07 00:00:00.0 6.7349 550
95 764.8578 2022-09-08 00:00:00.0 6.7956 550
96 768.7785 2022-09-09 00:00:00.0 3.9207 550
97 772.8803 2022-09-10 00:00:00.0 4.1018 550
98 778.6535 2022-09-11 00:00:00.0 5.7732 550
99 784.9041 2022-09-12 00:00:00.0 6.2506 550
100 788.6547 2022-09-13 00:00:00.0 3.7506 550
101 794.9392 2022-09-14 00:00:00.0 6.2845 550
102 801.7340 2022-09-15 00:00:00.0 6.7948 550
103 806.4013 2022-09-16 00:00:00.0 4.6673 550
104 811.4271 2022-09-17 00:00:00.0 5.0258 550
105 818.0366 2022-09-18 00:00:00.0 6.6095 550
106 822.9731 2022-09-19 00:00:00.0 4.9365 550
107 827.2113 2022-09-20 00:00:00.0 4.2382 550
108 828.9604 2022-09-21 00:00:00.0 1.7491 550
109 831.4469 2022-09-22 00:00:00.0 2.4865 550
110 834.7179 2022-09-23 00:00:00.0 3.2710 550
111 840.7173 2022-09-24 00:00:00.0 5.9994 550
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '550') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-09-24'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/24/2022 6 841
9/23/2022 3 835
9/22/2022 2 831
9/21/2022 2 829
9/20/2022 4 827
9/19/2022 5 823
9/18/2022 7 818
9/17/2022 5 811
9/16/2022 5 806
9/15/2022 7 802
9/14/2022 6 795
9/13/2022 4 789
9/12/2022 6 785
9/11/2022 6 779
9/10/2022 4 773
9/9/2022 4 769
9/8/2022 7 765
9/7/2022 7 758
9/6/2022 8 751
9/5/2022 9 743
9/4/2022 8 734
9/3/2022 7 727
9/2/2022 8 719
9/1/2022 7 712
8/31/2022 7 705
8/30/2022 7 698
8/29/2022 8 691
8/28/2022 9 683
8/27/2022 8 674
8/26/2022 8 666
8/25/2022 7 658
8/24/2022 8 651
8/23/2022 9 643
8/22/2022 9 634
8/21/2022 8 624
8/20/2022 8 617
8/19/2022 9 609
8/18/2022 9 600
8/17/2022 9 591
8/16/2022 8 582
8/15/2022 9 573
8/14/2022 9 564
8/13/2022 9 555
8/12/2022 9 546
8/11/2022 8 537
8/10/2022 8 529
8/9/2022 8 522
8/8/2022 8 514
8/7/2022 6 506
8/6/2022 7 500
8/5/2022 9 493
8/4/2022 8 484
8/3/2022 8 476
8/2/2022 9 467
8/1/2022 9 459
7/31/2022 9 450
7/30/2022 8 441
7/29/2022 7 434
7/28/2022 8 426
7/27/2022 7 418
7/26/2022 8 411
7/25/2022 8 403
7/24/2022 7 395
7/23/2022 8 388
7/22/2022 8 379
7/21/2022 8 371
7/20/2022 9 363
7/19/2022 10 354
7/18/2022 9 344
7/17/2022 7 336
7/16/2022 9 329
7/15/2022 8 320
7/14/2022 9 312
7/13/2022 9 303
7/12/2022 9 294
7/11/2022 9 285
7/10/2022 9 276
7/9/2022 9 267
7/8/2022 8 258
7/7/2022 9 250
7/6/2022 9 241
7/5/2022 9 232
7/4/2022 9 223
7/3/2022 9 214
7/2/2022 7 205
7/1/2022 6 198
6/30/2022 8 192
6/29/2022 8 184
6/28/2022 8 175
6/27/2022 8 168
6/26/2022 7 160
6/25/2022 6 153
6/24/2022 9 146
6/23/2022 8 137
6/22/2022 8 129
6/21/2022 9 121
6/20/2022 10 112
6/19/2022 6 103
6/18/2022 8 97
6/17/2022 9 89
6/16/2022 8 81
6/15/2022 6 73
6/14/2022 7 67
6/13/2022 9 60
6/12/2022 9 51
6/11/2022 8 42
6/10/2022 8 34
6/9/2022 7 25
6/8/2022 7 18
6/7/2022 6 11