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 5.5658 2022-06-06 00:00:00.0 5.5658 554
2 12.4110 2022-06-07 00:00:00.0 6.8452 554
3 19.3672 2022-06-08 00:00:00.0 6.9562 554
4 26.0907 2022-06-09 00:00:00.0 6.7235 554
5 35.2138 2022-06-10 00:00:00.0 9.1231 554
6 44.3867 2022-06-11 00:00:00.0 9.1729 554
7 53.6727 2022-06-12 00:00:00.0 9.2860 554
8 62.5301 2022-06-13 00:00:00.0 8.8574 554
9 71.7568 2022-06-14 00:00:00.0 9.2267 554
10 80.5266 2022-06-15 00:00:00.0 8.7698 554
11 88.8788 2022-06-16 00:00:00.0 8.3522 554
12 97.6519 2022-06-17 00:00:00.0 8.7731 554
13 106.2778 2022-06-18 00:00:00.0 8.6259 554
14 110.8324 2022-06-19 00:00:00.0 4.5546 554
15 118.4566 2022-06-20 00:00:00.0 7.6242 554
16 127.5356 2022-06-21 00:00:00.0 9.0790 554
17 135.8619 2022-06-22 00:00:00.0 8.3263 554
18 142.6998 2022-06-23 00:00:00.0 6.8379 554
19 152.1147 2022-06-24 00:00:00.0 9.4149 554
20 159.7143 2022-06-25 00:00:00.0 7.5996 554
21 167.7547 2022-06-26 00:00:00.0 8.0404 554
22 176.3293 2022-06-27 00:00:00.0 8.5746 554
23 184.5768 2022-06-28 00:00:00.0 8.2475 554
24 192.7207 2022-06-29 00:00:00.0 8.1439 554
25 202.1425 2022-06-30 00:00:00.0 9.4218 554
26 210.2678 2022-07-01 00:00:00.0 8.1253 554
27 218.0699 2022-07-02 00:00:00.0 7.8021 554
28 227.0027 2022-07-03 00:00:00.0 8.9328 554
29 236.5094 2022-07-04 00:00:00.0 9.5067 554
30 245.9843 2022-07-05 00:00:00.0 9.4749 554
31 254.8714 2022-07-06 00:00:00.0 8.8871 554
32 264.3015 2022-07-07 00:00:00.0 9.4301 554
33 272.9779 2022-07-08 00:00:00.0 8.6764 554
34 280.7692 2022-07-09 00:00:00.0 7.7913 554
35 289.7438 2022-07-10 00:00:00.0 8.9746 554
36 299.1883 2022-07-11 00:00:00.0 9.4445 554
37 308.6230 2022-07-12 00:00:00.0 9.4347 554
38 317.3286 2022-07-13 00:00:00.0 8.7056 554
39 326.7632 2022-07-14 00:00:00.0 9.4346 554
40 335.0494 2022-07-15 00:00:00.0 8.2862 554
41 343.7126 2022-07-16 00:00:00.0 8.6632 554
42 349.4343 2022-07-17 00:00:00.0 5.7217 554
43 357.2999 2022-07-18 00:00:00.0 7.8656 554
44 366.9306 2022-07-19 00:00:00.0 9.6307 554
45 376.1019 2022-07-20 00:00:00.0 9.1713 554
46 385.1397 2022-07-21 00:00:00.0 9.0378 554
47 394.2079 2022-07-22 00:00:00.0 9.0682 554
48 403.4937 2022-07-23 00:00:00.0 9.2858 554
49 412.2352 2022-07-24 00:00:00.0 8.7415 554
50 421.0681 2022-07-25 00:00:00.0 8.8329 554
51 430.0255 2022-07-26 00:00:00.0 8.9574 554
52 438.3281 2022-07-27 00:00:00.0 8.3026 554
53 446.9552 2022-07-28 00:00:00.0 8.6271 554
54 455.5449 2022-07-29 00:00:00.0 8.5897 554
55 463.0974 2022-07-30 00:00:00.0 7.5525 554
56 472.3550 2022-07-31 00:00:00.0 9.2576 554
57 481.1646 2022-08-01 00:00:00.0 8.8096 554
58 489.0279 2022-08-02 00:00:00.0 7.8633 554
59 498.2149 2022-08-03 00:00:00.0 9.1870 554
60 506.3264 2022-08-04 00:00:00.0 8.1115 554
61 514.5888 2022-08-05 00:00:00.0 8.2624 554
62 522.9087 2022-08-06 00:00:00.0 8.3199 554
63 529.4015 2022-08-07 00:00:00.0 6.4928 554
64 537.5777 2022-08-08 00:00:00.0 8.1762 554
65 547.0047 2022-08-09 00:00:00.0 9.4270 554
66 555.1946 2022-08-10 00:00:00.0 8.1899 554
67 561.9959 2022-08-11 00:00:00.0 6.8013 554
68 571.3906 2022-08-12 00:00:00.0 9.3947 554
69 580.0590 2022-08-13 00:00:00.0 8.6684 554
70 588.1642 2022-08-14 00:00:00.0 8.1052 554
71 597.6045 2022-08-15 00:00:00.0 9.4403 554
72 606.3778 2022-08-16 00:00:00.0 8.7733 554
73 614.6513 2022-08-17 00:00:00.0 8.2735 554
74 624.4000 2022-08-18 00:00:00.0 9.7487 554
75 633.7742 2022-08-19 00:00:00.0 9.3742 554
76 642.1006 2022-08-20 00:00:00.0 8.3264 554
77 649.7508 2022-08-21 00:00:00.0 7.6502 554
78 658.4275 2022-08-22 00:00:00.0 8.6767 554
79 667.5757 2022-08-23 00:00:00.0 9.1482 554
80 675.9280 2022-08-24 00:00:00.0 8.3523 554
81 682.9523 2022-08-25 00:00:00.0 7.0243 554
82 691.9324 2022-08-26 00:00:00.0 8.9801 554
83 700.3683 2022-08-27 00:00:00.0 8.4359 554
84 709.8173 2022-08-28 00:00:00.0 9.4490 554
85 719.1527 2022-08-29 00:00:00.0 9.3354 554
86 727.5609 2022-08-30 00:00:00.0 8.4082 554
87 734.9464 2022-08-31 00:00:00.0 7.3855 554
88 742.1427 2022-09-01 00:00:00.0 7.1963 554
89 750.5330 2022-09-02 00:00:00.0 8.3903 554
90 757.6001 2022-09-03 00:00:00.0 7.0671 554
91 765.2462 2022-09-04 00:00:00.0 7.6461 554
92 773.5809 2022-09-05 00:00:00.0 8.3347 554
93 782.5516 2022-09-06 00:00:00.0 8.9707 554
94 789.9537 2022-09-07 00:00:00.0 7.4021 554
95 798.2448 2022-09-08 00:00:00.0 8.2911 554
96 804.7596 2022-09-09 00:00:00.0 6.5148 554
97 809.7290 2022-09-10 00:00:00.0 4.9694 554
98 815.9274 2022-09-11 00:00:00.0 6.1984 554
99 823.6179 2022-09-12 00:00:00.0 7.6905 554
100 828.3531 2022-09-13 00:00:00.0 4.7352 554
101 834.0331 2022-09-14 00:00:00.0 5.6800 554
102 841.3217 2022-09-15 00:00:00.0 7.2886 554
103 846.5603 2022-09-16 00:00:00.0 5.2386 554
104 853.3358 2022-09-17 00:00:00.0 6.7755 554
105 861.4109 2022-09-18 00:00:00.0 8.0751 554
106 867.7284 2022-09-19 00:00:00.0 6.3175 554
107 875.4605 2022-09-20 00:00:00.0 7.7321 554
108 878.7650 2022-09-21 00:00:00.0 3.3045 554
109 881.0991 2022-09-22 00:00:00.0 2.3341 554
110 885.6170 2022-09-23 00:00:00.0 4.5179 554
111 893.3946 2022-09-24 00:00:00.0 7.7776 554
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '554') 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 8 893
9/23/2022 5 886
9/22/2022 2 881
9/21/2022 3 879
9/20/2022 8 875
9/19/2022 6 868
9/18/2022 8 861
9/17/2022 7 853
9/16/2022 5 847
9/15/2022 7 841
9/14/2022 6 834
9/13/2022 5 828
9/12/2022 8 824
9/11/2022 6 816
9/10/2022 5 810
9/9/2022 7 805
9/8/2022 8 798
9/7/2022 7 790
9/6/2022 9 783
9/5/2022 8 774
9/4/2022 8 765
9/3/2022 7 758
9/2/2022 8 751
9/1/2022 7 742
8/31/2022 7 735
8/30/2022 8 728
8/29/2022 9 719
8/28/2022 9 710
8/27/2022 8 700
8/26/2022 9 692
8/25/2022 7 683
8/24/2022 8 676
8/23/2022 9 668
8/22/2022 9 658
8/21/2022 8 650
8/20/2022 8 642
8/19/2022 9 634
8/18/2022 10 624
8/17/2022 8 615
8/16/2022 9 606
8/15/2022 9 598
8/14/2022 8 588
8/13/2022 9 580
8/12/2022 9 571
8/11/2022 7 562
8/10/2022 8 555
8/9/2022 9 547
8/8/2022 8 538
8/7/2022 6 529
8/6/2022 8 523
8/5/2022 8 515
8/4/2022 8 506
8/3/2022 9 498
8/2/2022 8 489
8/1/2022 9 481
7/31/2022 9 472
7/30/2022 8 463
7/29/2022 9 456
7/28/2022 9 447
7/27/2022 8 438
7/26/2022 9 430
7/25/2022 9 421
7/24/2022 9 412
7/23/2022 9 403
7/22/2022 9 394
7/21/2022 9 385
7/20/2022 9 376
7/19/2022 10 367
7/18/2022 8 357
7/17/2022 6 349
7/16/2022 9 344
7/15/2022 8 335
7/14/2022 9 327
7/13/2022 9 317
7/12/2022 9 309
7/11/2022 9 299
7/10/2022 9 290
7/9/2022 8 281
7/8/2022 9 273
7/7/2022 9 264
7/6/2022 9 255
7/5/2022 9 246
7/4/2022 10 237
7/3/2022 9 227
7/2/2022 8 218
7/1/2022 8 210
6/30/2022 9 202
6/29/2022 8 193
6/28/2022 8 185
6/27/2022 9 176
6/26/2022 8 168
6/25/2022 8 160
6/24/2022 9 152
6/23/2022 7 143
6/22/2022 8 136
6/21/2022 9 128
6/20/2022 8 118
6/19/2022 5 111
6/18/2022 9 106
6/17/2022 9 98
6/16/2022 8 89
6/15/2022 9 81
6/14/2022 9 72
6/13/2022 9 63
6/12/2022 9 54
6/11/2022 9 44
6/10/2022 9 35
6/9/2022 7 26
6/8/2022 7 19
6/7/2022 7 12