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

Groups > comp.lang.php > #2033 > unrolled thread

[newbie] datetime issues

Back to article view | Back to comp.lang.php

Contents

  [newbie] datetime issues "Jeff" <it_consultant1@hotmail.com.NOSPAM> - 2011-06-09 00:54 +0200
    Re: [newbie] datetime issues sheldonlg <sheldonlg@thevillages.net> - 2011-06-08 20:12 -0400

#2033 — [newbie] datetime issues

hi

php 5

I'm trying to construct an sql query where I need to filter between 2 dates. 
So how do I dynamically create those datetime values?

Tip: The day value will always be 1 (or 01 ?).

I will dynamically select values from the entire last month.

I tryed this:
convert('2012-'.date('m').'-01 00:00:00',DATETIME)
which gave me syntax error and also I need to some more if testing on year. 
So hope there is a better way of doing this

please help me 

[toc] | [next] | [standalone]

#2034

On 6/8/2011 6:54 PM, Jeff wrote:
> hi
>
> php 5
>
> I'm trying to construct an sql query where I need to filter between 2 dates.
> So how do I dynamically create those datetime values?
>
> Tip: The day value will always be 1 (or 01 ?).
>
> I will dynamically select values from the entire last month.
>
> I tryed this:
> convert('2012-'.date('m').'-01 00:00:00',DATETIME)
> which gave me syntax error and also I need to some more if testing on year.
> So hope there is a better way of doing this
>
> please help me

What do you mean by "from the entire last month"?  The expression you 
have will give for June, for example, '2012-06-01 00:00:00' which is 
already in DATETIME format (which I assume is how your data are stored 
in that column).  So, if you want everything from the first of June it 
would be

$sql ="SELECT WHATEVER FROM WHEREVER ";
$sql .= "WHERE THE_COL_NAME >= '2012-" . date('m') . "-01 00:00:00'";

Note that the final value of $sql in this case, for June, would be

SELECT WHATEVER FROM WHEREVER WHERE
THE_COL_NAME >= '2012-06-01 00:00:00'

-- 
Shelly

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web