One year back query datetime

Question

I want to get all records from now between a year ago but it's not working exactly. Made in CodeIgniter

This is my query , antything wrong with it ? :

    $currentDate = date("Y-m-d H:m:s");
    $yeardate=date('Y-m-d H:m:s', strtotime('-1 year'));
    $this->db->select('TimeStamp');
    $this->db->where('Transaction', 'COMPLETED');
    $this->db->where('TimeStamp>=',$yeardate);
    $this->db->where('TimeStamp<=',$currentDate);
    $query = $this->db->get('R_Logs');
    $results = $query->result();

Thanks in advance

Define `not working exactly.`. – Amal Murali Oct 21 '13 at 14:39 — Amal Murali, Oct 21 '13 at 14:39

score 1 · Answer 1 · answered Oct 21 '13 at 14:50

1

I forgot to add a space between TimeStamp <= and TimeStamp >= . My bad.

answered Oct 21 '13 at 14:50

David

840
6
17
37

score 0 · Answer 2 · edited May 23 '17 at 12:05

0

I think it might be easier to try Epoch time and then query off of that - e.g. Get epoch for a specific date using Javascript

That will convert the date to number of days since January 1, 1970. then from that you can subtract 365 days ( or use the yearInteger %4 trick to find out if it is a leap year)

edited May 23 '17 at 12:05

Community

1
1

answered Oct 21 '13 at 14:44

Andrew Bowman

798
9
21

score 0 · Answer 3 · answered Oct 21 '13 at 14:47

0

Change these two lines any try once:

$currentDate    = date("Y-m-d H:i:s");
$yeardate       = strtotime(date('Y-m-d H:i:s') . ' -1 year');

Dump your query and debug:

echo $this->db->last_query();

answered Oct 21 '13 at 14:47

Nil'z

7,487
1
18
28

One year back query datetime

3 Answers3