Skip to content

Instantly share code, notes, and snippets.

@jhannah
Created March 5, 2011 05:49
Show Gist options
  • Select an option

  • Save jhannah/856158 to your computer and use it in GitHub Desktop.

Select an option

Save jhannah/856158 to your computer and use it in GitHub Desktop.
linode main:
mysql> select username, created from users where date(created) >= '2011-03-01';
+-----------------+---------------------+
| username | created |
+-----------------+---------------------+
| nanaki_rogue | 2011-03-01 00:33:46 |
| monkyt | 2011-03-01 02:25:09 |
| greig.barclay | 2011-03-02 01:16:54 |
| carnaval | 2011-03-03 16:33:30 |
| nanocarbono | 2011-03-03 19:44:27 |
| vetutorials | 2011-03-04 01:17:05 |
| mbs.horstmann.e | 2011-03-04 03:35:31 |
| cassandra_ebner | 2011-03-04 03:50:08 |
| bluered_library | 2011-03-04 05:41:42 |
| spence.52 | 2011-03-05 00:37:07 |
| ronpenkar | 2011-03-05 04:39:01 |
+-----------------+---------------------+
11 rows in set (0.02 sec)
DH channelmeter_staging
mysql> select username, created from users where date(created) >= '2011-03-01';
+-----------------+---------------------+
| username | created |
+-----------------+---------------------+
| greig.barclay | 2011-03-01 17:16:54 |
| carnaval | 2011-03-03 08:33:30 |
| nanocarbono | 2011-03-03 11:44:27 |
| vetutorials | 2011-03-03 17:17:05 |
| mbs.horstmann.e | 2011-03-03 19:35:31 |
| cassandra_ebner | 2011-03-03 19:50:08 |
| bluered_library | 2011-03-03 21:41:42 |
| spence.52 | 2011-03-04 16:37:07 |
| ronpenkar | 2011-03-04 20:39:01 |
+-----------------+---------------------+
9 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment