[Nikas]

Hi all,

I have stored unix timestamp in my database. I wanted to do a query to select date between months.

This is my query to convert the time from unix to normal timestamp

PHP Code:

$Q = $db->query("SELECT opened FROM phpdesk_tickets");

        while ($F = $db->fetch($Q)) {

            $dateconvert = date('Y-m-d', $F['opened']);

            echo "<br>".$F['opened']." // ".$dateconvert; } 

This is the result

PHP Code:

1190477670 // 2007-09-22

1190486212 // 2007-09-22

1190486393 // 2007-09-22

1190486415 // 2007-09-22

1190486526 // 2007-09-22

1190486622 // 2007-09-22

1190645584 // 2007-09-24

1191047338 // 2007-09-29

1192166236 // 2007-10-12

1192166750 // 2007-10-12

1199038391 // 2007-12-30

1199038276 // 2007-12-30

1199038061 // 2007-12-30

1199038435 // 2007-12-30

1199038555 // 2007-12-30

1199038761 // 2007-12-30

1199039346 // 2007-12-30

1199039530 // 2007-12-30

1199039736 // 2007-12-30

1199039863 // 2007-12-30

1199041151 // 2007-12-30

1199041224 // 2007-12-30 

But I'm not sure how can I do a query to select between months.
Any one can guide me through?

Thanks.

[Nico]

SELECT * FROM `phpdesk_tickets` WHERE `opened` BETWEEN timestamp1 AND timestamp2 

If you need to convert a date to timestamp, use strtotime() or mktime().

[Nikas]

Thanks. I think what I need is strtotime()

[mab]

If your date was stored in the database using a mysql DATE or DATETIME data type, there are several msyql functions that would let you compare and select the dates you want directly in your query, without any need to convert values.

[Nikas]

Yes, mab.

I'm currently working on a open source, and the date stored is in unix time, as I don't wish to mess things up. I'm converting the time instead of using DATETIME data type.