Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13413

Re: select date from DATETIME field

Show all headers | View raw

On Sat, 19 Apr 2014 15:39:52 -0400, pentapus wrote:

> I have a DATETIME field that I am looking for rows that just match the
> date. What is the easy way?
> 
> I thought SELECT * FROM some_table WHERE DATE(time-date-field) = ... but
> no go...

I thought this was a php newsgroup, you seem to have confused it with 
comp.databases.[something] or possibly alt.php.sql

-- 
Denis McMahon, denismfmcmahon@gmail.com

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

select date from DATETIME field pentapus <pentapus@example.com> - 2014-04-19 15:39 -0400
  Re: select date from DATETIME field Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2014-04-19 15:50 -0400
    Re: select date from DATETIME field pentapus <pentapus@example.com> - 2014-04-19 17:44 -0400
      Re: select date from DATETIME field Luuk <luuk@invalid.lan> - 2014-04-20 15:13 +0200
  Re: select date from DATETIME field Tim Streater <timstreater@greenbee.net> - 2014-04-19 20:56 +0000
    Re: select date from DATETIME field The Natural Philosopher <tnp@invalid.invalid> - 2014-04-19 22:21 +0100
  Re: select date from DATETIME field Denis McMahon <denismfmcmahon@gmail.com> - 2014-04-19 21:01 +0000
    Re: select date from DATETIME field pentapus <pentapus@example.com> - 2014-04-19 17:39 -0400

csiph-web