Так хватит стонать! - все в пределах флюктуаций - чуть теплее да и только
Вот выборки из независимых от гидрометцентра баз(12.2005,2006,1998):
(Прим : ,94000006 - это +0.94 градуса по цельсию.)
Дата* Замер Температура
------------------- --------- ---------
01-12-2005 14:00:00 765 1,98
02-12-2005 14:00:00 765 ,21999995
03-12-2005 14:00:00 765 -1,173333
04-12-2005 14:00:00 765 -1,593333
05-12-2005 14:00:00 765 -2,14
06-12-2005 14:00:00 765 -3,453334
07-12-2005 14:00:00 765 -1,1
07-12-2005 14:00:00 765 -1,1
08-12-2005 14:00:00 765 2,0800002
08-12-2005 14:00:00 765 2,0800002
09-12-2005 14:00:00 765 2,3266666
10-12-2005 14:00:00 765 -4,34
11-12-2005 14:00:00 765 -2,566666
12-12-2005 14:00:00 765 -,6533332
13-12-2005 14:00:00 765 ,94000006
14-12-2005 14:00:00 765 1,2133335
15-12-2005 14:00:00 765 -1,133333
16-12-2005 14:00:00 765 -,9199999
17-12-2005 14:00:00 765 1,4066668
18-12-2005 14:00:00 765 ,70000005
19-12-2005 14:00:00 765 1,4666668
20-12-2005 14:00:00 765 -2,76
21-12-2005 14:00:00 765 -4,42
22-12-2005 14:00:00 765 -3,973333
23-12-2005 14:00:00 765 -5,726667
24-12-2005 14:00:00 765 -4,866666
25-12-2005 14:00:00 765 -3,686666
26-12-2005 14:00:00 765 -5,073333
27-12-2005 14:00:00 765 -4,713333
28-12-2005 14:00:00 765 -,4066666
29-12-2005 14:00:00 765 ,37333342
30-12-2005 14:00:00 765 -2,326667
SQL> spool off
------------------- --------- ---------
01-12-2006 14:00:00 765 4,4400001
02-12-2006 14:00:00 765 5,04
03-12-2006 14:00:00 765 3,54
04-12-2006 14:00:00 765 2,4400001
05-12-2006 14:00:00 765 5,2399998
06-12-2006 14:00:00 765 3,6400001
07-12-2006 14:00:00 765 3,24
08-12-2006 14:00:00 765 4,3400002
09-12-2006 14:00:00 765 4,6399999
10-12-2006 14:00:00 765 3,3399999
11-12-2006 14:00:00 765 2,3399999
12-12-2006 14:00:00 765 2,74
13-12-2006 14:00:00 765 2,04
14-12-2006 14:00:00 765 1,5700001
15-12-2006 14:00:00 765 3,25
16-12-2006 14:00:00 765 7,0300002
17-12-2006 14:00:00 765 6,23
18-12-2006 14:00:00 765 3,6400001
SQL> select to_char(t,'DD-MM-YYYY HH24:MI:SS'),ID,V from energostat.ti_data where t between to_date('1-12-1999
2 0:0:0','DD-MM-YYYY HH24:MI:SS') and to_date('31-12-1999 00:00:00','DD-MM-YYYY HH24:MI:SS') and
3 to_char(t,'HH24')='14' and to_char(t,'MI')='00' and ID=765 ;
TO_CHAR(T,'DD-MM-YY ID V
------------------- --------- ---------
01-12-1999 14:00:00 765 0
02-12-1999 14:00:00 765 0
03-12-1999 14:00:00 765 0
04-12-1999 14:00:00 765 0
05-12-1999 14:00:00 765 0
06-12-1999 14:00:00 765 0
07-12-1999 14:00:00 765 -7,9
08-12-1999 14:00:00 765 -,3
09-12-1999 14:00:00 765 2,7
10-12-1999 14:00:00 765 2,5
11-12-1999 14:00:00 765 3
12-12-1999 14:00:00 765 2,4
13-12-1999 14:00:00 765 1,4
14-12-1999 14:00:00 765 1,2
15-12-1999 14:00:00 765 1,5
16-12-1999 14:00:00 765 2,9
17-12-1999 14:00:00 765 2
18-12-1999 14:00:00 765 -1,7
19-12-1999 14:00:00 765 ,3
20-12-1999 14:00:00 765 1
21-12-1999 14:00:00 765 ,7
22-12-1999 14:00:00 765 -5
23-12-1999 14:00:00 765 -4,7
24-12-1999 14:00:00 765 -6
25-12-1999 14:00:00 765 -8,3
26-12-1999 14:00:00 765 -5,3
27-12-1999 14:00:00 765 1,3
28-12-1999 14:00:00 765 1,7
29-12-1999 14:00:00 765 ,3
30-12-1999 14:00:00 765 -,6
SQL> spool off
[Ответ]