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

Groups > comp.lang.php > #13410

Re: select date from DATETIME field

Show all headers | View raw

In article <liuje4$keu$1@news.albasani.net>, pentapus
<pentapus@example.com> 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...

Have you seen the doctor about this problem, or has your brain already
been amputated?

What OS?
What version of PHP?
What database?

and so on.

-- 
"I am enclosing two tickets to the first night of my new play; bring a
friend.... if you have one." - GB Shaw to Churchill "Cannot possibly
attend first night, will attend second...  if there is one." - Winston
Churchill, in response.

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