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 #185600 is a reply to message #185599]

Sat, 19 April 2014 19:50

Lew Pitcher
Messages: 60
Registered: April 2013

Karma:

Member

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';

Here's an example from something I'm working on...

mysql> select recipe_name, recipe_date from recipe where date(recipe_date)
= '2014-04-14';
+--------------------+---------------------+
| recipe_name | recipe_date |
+--------------------+---------------------+
| Beef and Corn Bake | 2014-04-14 20:27:13 |
+--------------------+---------------------+
1 row in set (0.00 sec)

mysql> select recipe_name, recipe_date from recipe where date(recipe_date)
= '2014-04-03';
+---------------------+---------------------+
| recipe_name | recipe_date |
+---------------------+---------------------+
| Coffee Rubbed Steak | 2014-04-03 09:14:20 |
+---------------------+---------------------+
1 row in set (0.00 sec)

HTH
--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request

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:26:53 GMT 2024

Total time taken to generate the page: 0.04086 seconds