fork download
copy 
  1. CREATE TABLE myTable (`id` int auto_increment primary key, `time` date_time);
  2. INSERT INTO myTable (`time`) VALUES ('2014-01-01 11:12:13');
  3. INSERT INTO myTable (`time`) VALUES ('2014-01-11 21:12:13');
  4. INSERT INTO myTable (`time`) VALUES ('2014-03-11 21:12:13');
  5. SELECT * FROM myTable WHERE `time` LIKE '2014-01%';
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
|2014-01-01 11:12:13
|2014-01-11 21:12:13
https://ideone.com/kJEgnV
language:
SQLite (sqlite 3.27.2)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!