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 #185606 is a reply to message #185604]

Sat, 19 April 2014 21:39

pentapus
Messages: 3
Registered: April 2014

Karma:

Junior Member

On 4/19/2014 5:01 PM, Denis McMahon wrote:
> 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

Indeed. I sent this off when quickly when I had company at the door. It
should have gone elsewhere. My bad. I did not know of alt.php.sql, I
intended comp.databases.mysql

--
pentapus

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: Sun Nov 24 01:58:54 GMT 2024

Total time taken to generate the page: 0.03532 seconds