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 9.2240 2017-05-15 00:00:00.0 9.2240 222
2 16.1199 2017-05-16 00:00:00.0 6.8959 222
3 17.8908 2017-05-17 00:00:00.0 1.7709 222
4 18.7296 2017-05-18 00:00:00.0 0.8388 222
5 23.2112 2017-05-19 00:00:00.0 4.4816 222
6 28.1092 2017-05-20 00:00:00.0 4.8980 222
7 29.3536 2017-05-21 00:00:00.0 1.2444 222
8 32.4883 2017-05-22 00:00:00.0 3.1347 222
9 39.6944 2017-05-23 00:00:00.0 7.2061 222
10 47.7332 2017-05-24 00:00:00.0 8.0388 222
11 55.5108 2017-05-25 00:00:00.0 7.7776 222
12 64.0776 2017-05-26 00:00:00.0 8.5668 222
13 72.5342 2017-05-27 00:00:00.0 8.4566 222
14 78.3092 2017-05-28 00:00:00.0 5.7750 222
15 80.4643 2017-05-29 00:00:00.0 2.1551 222
16 86.6908 2017-05-30 00:00:00.0 6.2265 222
17 95.5638 2017-05-31 00:00:00.0 8.8730 222
18 105.5128 2017-06-01 00:00:00.0 9.9490 222
19 114.3264 2017-06-02 00:00:00.0 8.8136 222
20 123.6153 2017-06-03 00:00:00.0 9.2889 222
21 133.5536 2017-06-04 00:00:00.0 9.9383 222
22 143.5487 2017-06-05 00:00:00.0 9.9951 222
23 153.3709 2017-06-06 00:00:00.0 9.8222 222
24 163.2847 2017-06-07 00:00:00.0 9.9138 222
25 173.2842 2017-06-08 00:00:00.0 9.9995 222
26 183.1842 2017-06-09 00:00:00.0 9.9000 222
27 193.1225 2017-06-10 00:00:00.0 9.9383 222
28 203.0715 2017-06-11 00:00:00.0 9.9490 222
29 212.4465 2017-06-12 00:00:00.0 9.3750 222
30 221.5888 2017-06-13 00:00:00.0 9.1423 222
31 231.0664 2017-06-14 00:00:00.0 9.4776 222
32 239.9394 2017-06-15 00:00:00.0 8.8730 222
33 248.8124 2017-06-16 00:00:00.0 8.8730 222
34 256.7874 2017-06-17 00:00:00.0 7.9750 222
35 264.4282 2017-06-18 00:00:00.0 7.6408 222
36 272.5915 2017-06-19 00:00:00.0 8.1633 222
37 281.2119 2017-06-20 00:00:00.0 8.6204 222
38 289.7241 2017-06-21 00:00:00.0 8.5122 222
39 298.8241 2017-06-22 00:00:00.0 9.1000 222
40 306.0302 2017-06-23 00:00:00.0 7.2061 222
41 310.5118 2017-06-24 00:00:00.0 4.4816 222
42 316.0990 2017-06-25 00:00:00.0 5.5872 222
43 324.7720 2017-06-26 00:00:00.0 8.6730 222
44 334.2164 2017-06-27 00:00:00.0 9.4444 222
45 343.5552 2017-06-28 00:00:00.0 9.3388 222
46 352.9302 2017-06-29 00:00:00.0 9.3750 222
47 361.8032 2017-06-30 00:00:00.0 8.8730 222
48 370.4236 2017-07-01 00:00:00.0 8.6204 222
49 378.9904 2017-07-02 00:00:00.0 8.5668 222
50 388.9042 2017-07-03 00:00:00.0 9.9138 222
51 398.4585 2017-07-04 00:00:00.0 9.5543 222
52 408.1807 2017-07-05 00:00:00.0 9.7222 222
53 417.9721 2017-07-06 00:00:00.0 9.7914 222
54 427.7879 2017-07-07 00:00:00.0 9.8158 222
55 437.7435 2017-07-08 00:00:00.0 9.9556 222
56 447.7237 2017-07-09 00:00:00.0 9.9802 222
57 457.7237 2017-07-10 00:00:00.0 10.0000 222
58 467.6910 2017-07-11 00:00:00.0 9.9673 222
59 476.4155 2017-07-12 00:00:00.0 8.7245 222
60 485.5992 2017-07-13 00:00:00.0 9.1837 222
61 495.3951 2017-07-14 00:00:00.0 9.7959 222
62 505.3869 2017-07-15 00:00:00.0 9.9918 222
63 515.2563 2017-07-16 00:00:00.0 9.8694 222
64 525.1069 2017-07-17 00:00:00.0 9.8506 222
65 534.7620 2017-07-18 00:00:00.0 9.6551 222
66 543.8186 2017-07-19 00:00:00.0 9.0566 222
67 553.5247 2017-07-20 00:00:00.0 9.7061 222
68 563.5063 2017-07-21 00:00:00.0 9.9816 222
69 573.0772 2017-07-22 00:00:00.0 9.5709 222
70 582.9466 2017-07-23 00:00:00.0 9.8694 222
71 592.9420 2017-07-24 00:00:00.0 9.9954 222
72 602.9374 2017-07-25 00:00:00.0 9.9954 222
73 612.9190 2017-07-26 00:00:00.0 9.9816 222
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '222') 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 613
7/25/2017 10 603
7/24/2017 10 593
7/23/2017 10 583
7/22/2017 10 573
7/21/2017 10 564
7/20/2017 10 554
7/19/2017 9 544
7/18/2017 10 535
7/17/2017 10 525
7/16/2017 10 515
7/15/2017 10 505
7/14/2017 10 495
7/13/2017 9 486
7/12/2017 9 476
7/11/2017 10 468
7/10/2017 10 458
7/9/2017 10 448
7/8/2017 10 438
7/7/2017 10 428
7/6/2017 10 418
7/5/2017 10 408
7/4/2017 10 398
7/3/2017 10 389
7/2/2017 9 379
7/1/2017 9 370
6/30/2017 9 362
6/29/2017 9 353
6/28/2017 9 344
6/27/2017 9 334
6/26/2017 9 325
6/25/2017 6 316
6/24/2017 4 311
6/23/2017 7 306
6/22/2017 9 299
6/21/2017 9 290
6/20/2017 9 281
6/19/2017 8 273
6/18/2017 8 264
6/17/2017 8 257
6/16/2017 9 249
6/15/2017 9 240
6/14/2017 9 231
6/13/2017 9 222
6/12/2017 9 212
6/11/2017 10 203
6/10/2017 10 193
6/9/2017 10 183
6/8/2017 10 173
6/7/2017 10 163
6/6/2017 10 153
6/5/2017 10 144
6/4/2017 10 134
6/3/2017 9 124
6/2/2017 9 114
6/1/2017 10 106
5/31/2017 9 96
5/30/2017 6 87
5/29/2017 2 80
5/28/2017 6 78
5/27/2017 8 73
5/26/2017 9 64
5/25/2017 8 56
5/24/2017 8 48
5/23/2017 7 40
5/22/2017 3 32
5/21/2017 1 29
5/20/2017 5 28
5/19/2017 4 23
5/18/2017 1 19
5/17/2017 2 18
5/16/2017 7 16
5/15/2017 9 9