FUDforum: comp.lang.php » select date from DATETIME field

Home » Imported messages » comp.lang.php » select date from DATETIME field

Show: Today's Messages :: Polls :: Message Navigator

Re: select date from DATETIME field [message #185610 is a reply to message #185607]

Sun, 20 April 2014 13:13

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

On 19-4-2014 23:44, pentapus wrote:
> On 4/19/2014 3:50 PM, Lew Pitcher wrote:
>> On Saturday 19 April 2014 15:39, in comp.lang.php, "pentapus"
>> <pentapus(at)example(dot)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...
>>
>> Try quoting the target date, as in
>> SELECT * from some_table WHERE DATE(time-date-field) = '2014-01-01';
>
> Thanks. That works. I'd left out the dashes (in my php date code) when I
> changed to DATETIME. Just knowing I had the sql syntax correct was
> enough to put me on the right track.
>>

This would be better:
SELECT * FROM some_table WHERE time-date-field between '2014-04-20' and
date('2014-04-20') + INTERVAL 1 DAY;

Because your database can make use of the index you defined on that
field.....

Report message to a moderator

[Message index]

		select date from DATETIME field By: pentapus on Sat, 19 April 2014 19:39
		Re: select date from DATETIME field By: Lew Pitcher on Sat, 19 April 2014 19:50
		Re: select date from DATETIME field By: pentapus on Sat, 19 April 2014 21:44
		Re: select date from DATETIME field By: Luuk on Sun, 20 April 2014 13:13
		Re: select date from DATETIME field By: Tim Streater on Sat, 19 April 2014 20:00
		Re: select date from DATETIME field By: The Natural Philosoph on Sat, 19 April 2014 21:21
		Re: select date from DATETIME field By: Denis McMahon on Sat, 19 April 2014 21:01
		Re: select date from DATETIME field By: pentapus on Sat, 19 April 2014 21:39

Previous Topic:	PHP Parse error: syntax error, unexpected '$sql' (T_VARIABLE) in
Next Topic:	Use PHP to populate a Mailing list from a webpage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 20:11:39 GMT 2024

Total time taken to generate the page: 0.04428 seconds