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 #185605 is a reply to message #185601]

Sat, 19 April 2014 21:21

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

On 19/04/14 21:56, Tim Streater wrote:
> In article <liuje4$keu$1(at)news(dot)albasani(dot)net>, 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...
>
> 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.
>

Do you really think it makes a difference?

--
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to
lead are elected by the least capable of producing, and where the
members of society least likely to sustain themselves or succeed, are
rewarded with goods and services paid for by the confiscated wealth of a
diminishing number of producers.

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 00:30:47 GMT 2024

Total time taken to generate the page: 0.04039 seconds