Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mariadb 10.1.8-MariaDB-log (root) [test]> create table t1 (id serial, t time);
- Query OK, 0 rows affected (0.01 sec)
- mariadb 10.1.8-MariaDB-log (root) [test]> insert into t1 (t) values ('12:30:00');
- Query OK, 1 row affected (0.00 sec)
- mariadb 10.1.8-MariaDB-log (root) [test]> select * from t1 where t = '2000-01-01 12:30:00';
- Empty set (0.00 sec)
- mysql 5.6.26-log (root) [test]> create table t1 (id serial, t time);
- Query OK, 0 rows affected (0.01 sec)
- mysql 5.6.26-log (root) [test]> insert into t1 (t) values ('12:30:00');
- Query OK, 1 row affected (0.00 sec)
- mysql 5.6.26-log (root) [test]> select * from t1 where t = '2000-01-01 12:30:00';
- +----+----------+
- | id | t |
- +----+----------+
- | 1 | 12:30:00 |
- +----+----------+
- 1 row in set (0.00 sec)
- postgresql=# create table t1 (id serial, t time);
- CREATE TABLE
- postgresql=# insert into t1 (t) values ('12:30:00');
- INSERT 0 1
- postgresql=# select * from t1 where t = '2000-01-01 12:30:00';
- t
- ----------
- 12:30:00
- (1 row)
- SQL Server
- create table t1 (id int identity(1,1), t time);
- insert into t1 (t) values ('12:30:00');
- select * from t1 where t = '2000-01-01 12:30:00';
- 1 12:30:00.0000000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement