php dates between two dates
Getting data posted in between two dates
How can I retrieve data from the database by querying records between two dates using CodeIgniter’s activerecord?
10 Answers 10
This looks like what you need:
Hope this will work
This worked great for me
This worked for me:
if your date filed is timestamp into database then this is the easy way to get record
If you want to compare SQL dates, you can try this:
That worked for me (PHP and MySQL).
Just simply write BETWEEN ‘<$startDate>‘ AND ‘<$endDate>‘ in where condition as
May this helpful to you. With Join of Three Tables
if you want to force using BETWEEN keyword on Codeigniter query helper. You can use where without escape false like this code. Works well on CI version 3.1.5. Hope its help someone.
Not the answer you’re looking for? Browse other questions tagged php sql codeigniter activerecord or ask your own question.
Linked
Related
Hot Network Questions
Subscribe to RSS
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.9.17.40238
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.
date_diff
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
Описание
Эта функция является псевдонимом: DateTime::diff()
User Contributed Notes 20 notes
Powerful Function to get two date difference.
/*
* A mathematical decimal difference between two informed dates
*
* Author: Sergio Abreu
* Website: http://sites.sitesbr.net
*
* Features:
* Automatic conversion on dates informed as string.
* Possibility of absolute values (always +) or relative (-/+)
*/
/* Enjoy and feedback me 😉 */
?>
This behavior looks really weird to me :
PHP is usually relaxed when it comes to data types however that is not the case with date and time. If all you need to do is compare a string date against today’s date you need to do the following:
//Output the array:
echo » ;
?>
This will output the following:
Array
(
[y] => 4
[m] => 10
[d] => 22
[h] => 0
[i] => 0
[s] => 0
[f] => 0
[weekday] => 0
[weekday_behavior] => 0
[first_last_day_of] => 0
[invert] => 1
[days] => 1787
[special_type] => 0
[special_amount] => 0
[have_weekday_relative] => 0
[have_special_relative] => 0
)
So you can simply use:
Even the top rated comment here, Sergio Abreu’s, doesn’t treat leap years entirely correctly. It should work between 1901 and 2099, but outside that it’ll be a little off.
If you want to find out the number of days between two dates, use below. You can change to a different unit from that. It looks a little insane, but keep in mind the full set of rules for leap years:
So in the functions below, we find the total numbers of days in full years since the mythical 1/1/0001, then add the number of days before the current one in the year passed. Do this for each date, then return the absolute value of the difference.
diff from datetime
My simple function to count up the number of weekdays between the dates (inclusive for both ends), one can add a holidays between the dates to take them into account as well as the weekends, the weekend days could also be changed.
This is a very simple function to calculate the difference between two datetime values, returning the result in seconds. To convert to minutes, just divide the result by 60. In hours, by 3600 and so on.
Here you have in this post http://softontherocks.blogspot.com/2014/12/calcular-la-edad-con-php.html the code to get the age of a person specifying the date of birth:
here a little solution of problem of missing date_diff function with php versions below 5.3.0
Here is how I solved the problem of missing date_diff function with php versions below 5.3.0
The function accepts two dates in string format (recognized by strtotime() hopefully), and returns the date difference in an array with the years as first element, respectively months as second, and days as last element.
It should be working in all cases, and seems to behave properly when moving through February.
I had to find the difference between two days (here is my solution without Date_diff()) :
This function will return count of sunday between inputed dates.
Other data_diff aviable for php5.3>=
PHP check if date between two dates
I got this code from Stackoverflow and changed it slightly to work with today’s date.
I want to check if today fits between two dates. But this is not working. What am I missing?
13 Answers 13
Edit: use or >= to count today’s date.
This is the right answer for your code. Just use the strtotime() php function.
You cannot compare date-strings. It is good habit to use PHP’s DateTime object instead:
Based on luttken’s answer. Thought I’d add my twist 🙂
Another solution would have been to consider date written as Ymd.
Written in this «format» this is much easy to compare dates.
You are comparing the dates as strings, which won’t work because the comparison is lexicographical. It’s the same issue as when sorting a text file, where a line 20 would appear after a line 100 because the contents are not treated as numbers but as sequences of ASCII codes. In addition, the dates created are all wrong because you are using a string format string where a timestamp is expected (second argument).
Instead of this you should be comparing timestamps of DateTime objects, for instance:
Your existing conditions will then work correctly.
You can use the mktime(hour, minute, seconds, month, day, year) function
Then comparison will be ok cause your 01-01-2015 is valid for PHP’s 32bit date-range, stated in strtotime’s manual.
An other solution (with the assumption you know your date formats are always YYYY/MM/DD with lead zeros) is the max() and min() function. I figure this is okay given all the other answers assume the yyyy-mm-dd format too and it’s the common naming convention for folders in file systems if ever you wanted to make sure they sorted in date order.
As others have said, given the order of the numbers you can compare the strings, no need for strtotime() function.
The advantage being you can stick more dates in there instead of just comparing two.
To work out if a date is in between two dates you could compare the result of min() and max()
It wouldn’t work with any other date format, but for that one it does. No need to convert to seconds and no need for date functions.
PHP: Return all dates between two dates in an array [duplicate]
Expected Input:
Expected Output:
26 Answers 26
You could also take a look at the DatePeriod class:
Which should get you an array with DateTime objects.
This is very very flexible.
Note that the answer provided by ViNce does NOT include the end date for the period.
If you are using PHP 5.3+, your best bet is to use a function like this:
Then, you would call the function as expected:
Note about DatePeriod class: You can use the 4th parameter of DatePeriod to exclude the start date ( DatePeriod::EXCLUDE_START_DATE ) but you cannot, at this time, include the end date.
Simple but like a charm:
This is short, sweet, and should work in PHP4+.
You must add $end->modify(‘+1 day’) to include last day of interval, for example the January will have a 31 days instead of 30 without using modify() method. This version of code will include the last day of the interval:
Short function. PHP 5.3 and up. Can take optional third param of any date format that strtotime can understand. Automatically reverses direction if end
many ways of getting this done, but finally it all depends on PHP version you are using. Here is summary of all solutions:
get PHP version:
PHP 5.3+
PHP 4+
Here is a function, that will return date ranges in both directions and it works on PHP >=5.2.2 :
Solution for PHP 5.2 with DateTime objects. But startDate MUST be before endDate.
it will return array like below:
I think it’s the shortest answer
Edit the code as you like
I love a solid one-liner!
My php discovery of the day was that array_push() returns the new number of elements in the array.
**Just a couple of important notes:
1- Date strings MUST BE validated before being fed to the function.
One more extension/consideration.
Imagine you have a multi-cultural (or sloppy) user base, and your function MUST be able to receive start and end dates in different valid formats AND you need to be able to output the array in any of the valid formats? By minor adjustment, I’ve provided a solution for that.
Now some people don’t 100% trust strtotime() because of some buggy behaviors. I think I’ve read that it will foul up when trying to jump a month from a leap-day. However, unless someone can reproduce it to prove me wrong, strtotime() is never going to let you down when you are only incrementing by one day.
Select data between two dates?
I’m using a database to store logs, with a column «date» which holds the date it was inserted. The format of the date is «MM/DD/YY». Please can anyone suggest how I would SELECT data in between two certain dates. For example, I tried this:
But I guess this doesn’t work because the dates aren’t numbers. Thanks for the help! 🙂
5 Answers 5
Use the BETWEEN keyword:
You can cast the fields as dates and then select between from_date and to_date
The answer to your question depends on the data type that is used to store the date field in the logs table.
You need to add single quotes to the date values ’01/01/12′:
Change date parameters into Unix timestamps and then compare them. Here is the code:
Not the answer you’re looking for? Browse other questions tagged php mysql select date or ask your own question.
Linked
Related
Hot Network Questions
Subscribe to RSS
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.9.17.40238
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.