/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
H A D | func_sapdb.result | 291 SELECT sec_to_time(3020399)=TIME('838:59:59'); 292 sec_to_time(3020399)=TIME('838:59:59') 294 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 295 sec_to_time(-3020399)=TIME('-838:59:59') 297 SELECT sec_to_time(-3020399)='-838:59:59'; 298 sec_to_time(-3020399)='-838:59:59' 300 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 301 time(sec_to_time(-3020399))=TIME('-838:59:59') 303 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 304 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
H A D | func_sapdb.result | 291 SELECT sec_to_time(3020399)=TIME('838:59:59'); 292 sec_to_time(3020399)=TIME('838:59:59') 294 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 295 sec_to_time(-3020399)=TIME('-838:59:59') 297 SELECT sec_to_time(-3020399)='-838:59:59'; 298 sec_to_time(-3020399)='-838:59:59' 300 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 301 time(sec_to_time(-3020399))=TIME('-838:59:59') 303 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 304 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
H A D | func_time_hires.result | 3 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 4 sec_to_time(12345) 03:25:45 5 sec_to_time(12345.6789) 03:25:45.6789 20 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 23 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 31 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 54 sec_to_time(12345) 03:25:45 78 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 79 sec_to_time(3020399.99999) sec_to_time(3020399.999999) sec_to_time(3020399.9999999) 81 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999); [all …]
|
H A D | func_time_hires.test | 8 select sec_to_time(12345), sec_to_time(12345.6789), sec_to_time(1234567e-2); 12 select sec_to_time(time_to_sec('1:2:3')), sec_to_time(time_to_sec('2:3:4.567890')); 13 select time_to_sec(sec_to_time(11111)), time_to_sec(sec_to_time(11111.22222)); 24 create table t1 select sec_to_time(12345), sec_to_time(12345.6789), 25 sec_to_time(1234567e-2), now(), curtime(0), 36 select sec_to_time(3020399.99999), sec_to_time(3020399.999999), sec_to_time(3020399.9999999); 37 select sec_to_time(-3020399.99999), sec_to_time(-3020399.999999), sec_to_time(-3020399.9999999);
|
H A D | func_sapdb.result | 291 SELECT sec_to_time(3020399)=TIME('838:59:59'); 292 sec_to_time(3020399)=TIME('838:59:59') 294 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 295 sec_to_time(-3020399)=TIME('-838:59:59') 297 SELECT sec_to_time(-3020399)='-838:59:59'; 298 sec_to_time(-3020399)='-838:59:59' 300 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 301 time(sec_to_time(-3020399))=TIME('-838:59:59') 303 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 304 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | func_sapdb.result | 285 SELECT sec_to_time(3020399)=TIME('838:59:59'); 286 sec_to_time(3020399)=TIME('838:59:59') 288 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 289 sec_to_time(-3020399)=TIME('-838:59:59') 291 SELECT sec_to_time(-3020399)='-838:59:59'; 292 sec_to_time(-3020399)='-838:59:59' 294 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 295 time(sec_to_time(-3020399))=TIME('-838:59:59') 297 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 298 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | func_sapdb.result | 285 SELECT sec_to_time(3020399)=TIME('838:59:59'); 286 sec_to_time(3020399)=TIME('838:59:59') 288 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 289 sec_to_time(-3020399)=TIME('-838:59:59') 291 SELECT sec_to_time(-3020399)='-838:59:59'; 292 sec_to_time(-3020399)='-838:59:59' 294 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 295 time(sec_to_time(-3020399))=TIME('-838:59:59') 297 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 298 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | func_sapdb.result | 285 SELECT sec_to_time(3020399)=TIME('838:59:59'); 286 sec_to_time(3020399)=TIME('838:59:59') 288 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 289 sec_to_time(-3020399)=TIME('-838:59:59') 291 SELECT sec_to_time(-3020399)='-838:59:59'; 292 sec_to_time(-3020399)='-838:59:59' 294 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 295 time(sec_to_time(-3020399))=TIME('-838:59:59') 297 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 298 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_sapdb.result | 287 SELECT sec_to_time(3020399)=TIME('838:59:59'); 288 sec_to_time(3020399)=TIME('838:59:59') 290 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 291 sec_to_time(-3020399)=TIME('-838:59:59') 293 SELECT sec_to_time(-3020399)='-838:59:59'; 294 sec_to_time(-3020399)='-838:59:59' 296 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 297 time(sec_to_time(-3020399))=TIME('-838:59:59') 299 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 300 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | func_sapdb.result | 285 SELECT sec_to_time(3020399)=TIME('838:59:59'); 286 sec_to_time(3020399)=TIME('838:59:59') 288 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 289 sec_to_time(-3020399)=TIME('-838:59:59') 291 SELECT sec_to_time(-3020399)='-838:59:59'; 292 sec_to_time(-3020399)='-838:59:59' 294 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 295 time(sec_to_time(-3020399))=TIME('-838:59:59') 297 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 298 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
H A D | func_sapdb.result | 287 SELECT sec_to_time(3020399)=TIME('838:59:59'); 288 sec_to_time(3020399)=TIME('838:59:59') 290 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 291 sec_to_time(-3020399)=TIME('-838:59:59') 293 SELECT sec_to_time(-3020399)='-838:59:59'; 294 sec_to_time(-3020399)='-838:59:59' 296 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 297 time(sec_to_time(-3020399))=TIME('-838:59:59') 299 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 300 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/r/ |
H A D | func_sapdb.result | 287 SELECT sec_to_time(3020399)=TIME('838:59:59'); 288 sec_to_time(3020399)=TIME('838:59:59') 290 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 291 sec_to_time(-3020399)=TIME('-838:59:59') 293 SELECT sec_to_time(-3020399)='-838:59:59'; 294 sec_to_time(-3020399)='-838:59:59' 296 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 297 time(sec_to_time(-3020399))=TIME('-838:59:59') 299 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 300 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_sapdb.result | 287 SELECT sec_to_time(3020399)=TIME('838:59:59'); 288 sec_to_time(3020399)=TIME('838:59:59') 290 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 291 sec_to_time(-3020399)=TIME('-838:59:59') 293 SELECT sec_to_time(-3020399)='-838:59:59'; 294 sec_to_time(-3020399)='-838:59:59' 296 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 297 time(sec_to_time(-3020399))=TIME('-838:59:59') 299 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 300 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/r/ |
H A D | func_sapdb.result | 287 SELECT sec_to_time(3020399)=TIME('838:59:59'); 288 sec_to_time(3020399)=TIME('838:59:59') 290 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 291 sec_to_time(-3020399)=TIME('-838:59:59') 293 SELECT sec_to_time(-3020399)='-838:59:59'; 294 sec_to_time(-3020399)='-838:59:59' 296 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 297 time(sec_to_time(-3020399))=TIME('-838:59:59') 299 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 300 time(sec_to_time(-3020399))=TIME('-838:59:58')
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/ |
H A D | func_sapdb.result | 285 SELECT sec_to_time(3020399)=TIME('838:59:59'); 286 sec_to_time(3020399)=TIME('838:59:59') 288 SELECT sec_to_time(-3020399)=TIME('-838:59:59'); 289 sec_to_time(-3020399)=TIME('-838:59:59') 291 SELECT sec_to_time(-3020399)='-838:59:59'; 292 sec_to_time(-3020399)='-838:59:59' 294 SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); 295 time(sec_to_time(-3020399))=TIME('-838:59:59') 297 SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); 298 time(sec_to_time(-3020399))=TIME('-838:59:58')
|