Home
last modified time | relevance | path

Searched refs:sec_to_time (Results 1 – 25 of 455) sorted by relevance

12345678910>>...19

/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_sapdb.result291 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 Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_sapdb.result291 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 Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_time_hires.result3 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 Dfunc_time_hires.test8 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 Dfunc_sapdb.result291 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 Dfunc_sapdb.result285 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 Dfunc_sapdb.result285 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 Dfunc_sapdb.result285 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 Dfunc_sapdb.result287 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 Dfunc_sapdb.result285 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 Dfunc_sapdb.result287 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 Dfunc_sapdb.result287 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 Dfunc_sapdb.result287 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 Dfunc_sapdb.result287 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 Dfunc_sapdb.result285 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')

12345678910>>...19