PHP - Unix Date/time To Day Only Not Time (newbie)

Code: [Select]
for ($z=1;$z<=30*365; $z++)
{
$bal[date('Y-m-d', strtotime("+ ". $z ." days"))] = $balance;//the balance of loan here.;
}

As you can see Im working on loading the daily balance of a 30 year loan in an array.

The code goes to hell in the year 2038.  I have scoured the internet for help.  I have gone to the wikipedia link and have looked at other posts but there isn't quite something that can help me.  How can I load dates beyond 01-18-2038 into my array?

I have heard of ways to do it with MySQL and the DATETIME() function, but that doesn't seem to make sense for what I am trying to accomplish.

Please point me in the right direction.

Thanks.

I have to two variables $cronlast and $cronnow in my php code.
I need to have the time 7am of previous day in $cronlast variable and  7am today in $cronnow variable.
I need the time in UNIX timestamp format.
So everyday when I print the variable I should have:

$cronlast=7am Yesterday(in Unix Timestamp)
$cronnow=7am Today(in Unix Timestamp)

I would appreciate any help.

Hello. I have a mysql database with an 'entrytime' field which contains the unix timestamp the record was added.

How do I create a mysql query to select all records for a given month/year?

For example, if I wanted to create a query to display all records for October 2010 how do I go about it?

I am at a loss and can't find my answer via google. Thanks in advance for any help!

I have a field set as datetime and want to compare that field to see if it is older then ten minutes. Can anyone help I am having a brain fart?

What is the best way to insert this time stamp into mysql?  This is the info I want...

Example:  Sunday, 28.1.11, 9:56

How would I also select time from the database using mysql?

Hey,

I need help with my date & time string.
I need to edit it do show in a string + also use it for calculating things like when the date has passed.

The string is like this:
Code: [Select]
<?php $string = '2011-01-01 00:00 AM'; ?>

So i wanted to check if there was a function that can automatically convert it, so it would say for example:


Quote

Sunday, 1st of January 2011
00:00 AM



But at the same time compare $string against server time to see if the date has expired?

Hope you can help

I have a batch script that reads from a timestamp.txt file to determine the last time it ran and I need to modify that by two hours.
What happens is the script will run to look for changes in the county records and their server time is two hours different from mine.

Code: [Select]
$fr=fopen("xml/timestamp.txt",'r');
$mydate=fread($fr, 50);
if ($incremental_updates == 1){
$default_template_file="xml/incremental_template.xml";
$default_config_name="xml/incremental.xml";
$contest=file_get_contents($default_template_file);
$contest=str_replace("{DATE_TAG}", $mydate, $contest);
$f=fopen($default_config_name,'w+');
fwrite($f, $contest);
fclose($f);
fclose($fr);
$fw=fopen("xml/timestamp.txt",'w');
fwrite($fw, substr(date('c'), 0, 19));
fclose($fw);
}else{
$default_config_name = "xml/full_update.xml";
}

I tried making a time stamp update look like $cur_timestamp=date("Y-m-d H:i:s", time() +14400); which is correct but it doesn't write to the text file properly.

Using the above fwrite($fw, substr(date('c'), 0, 19));
I get the correct results in the timestamp.txt file for my server time. I need it to be +14400

2011-05-25T08:27:51 would essentially become 2011-05-25T10:27:51 when it writes to the timestamp.txt

I hope that makes sense.

J

Hi!

The below dropdown will show dates/times every 15 minutes from 12am to 11:45pm for only 1 day.
I want it to show for 5 days, anyway I can do this?

Below code:

Code: [Select]
$start = strtotime('12:00am');
$end = strtotime('11:45pm');

echo '<select name="time">';
for ($i = $start; $i <= $end; $i += 900)
{
echo '<option>' . date('F j, Y, \a\t g:i a', $i);
}
echo '</select>';

Thanks for any help.

Hey,

I need help with date, I have stored dates in my table in this format:
i.e. 22.10.2011 but now use timestamp to store dates.

Problem is with this query the WHERE clause will find dates in the old format
and I want to change that to the new format.

Code: [Select]
for($i = $count; $i > 0; $i--)
{
$day = date("d.m.Y", mktime(0, 0, 0, date("m"), date("d") - $i, date("Y")));
$tmp = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates LIKE '%".$day."'"));
$array[] = $tmp['count'] ? $tmp['count'] : 0;
}

Am I making sense ?

I have selected datetime values from a MySQL database (originally stored with the NOW() method) and want to present them on a page formatted in a specific way. I succeded in making it work with the following php code:

$time = date('d/m Y H:i', strtotime($row['time']));
echo $time;

I am however unsure if this is the best way to do it? I noticed some comments at php.net stating that this method has some limitations due to UNIX time. I am confused. There seem to be many ways of formatting date and time. Maybe somebody can clarify the situation, and tell me what will be appropriate in the current situation? I will appreciate any suggestions ...   Erik 
Edited by erikla, 17 July 2014 - 10:01 AM.

I'm trying to make $time be a variable with the current time and I want it to have the same format as mysql.  I can't figure out what I am doing wrong here

Wrror: Warning: date_format() expects parameter 1 to be DateTime, integer given

Code: [Select]
$time = date_format(time(),'Y-m-d H:i:s');

Hello, first time poster here and PHP newbie. I was directed here by the html forum. I need help adding a time + date stamp to videos I upload to my web page. I have searched this and other formus and not seen a similar query / solution.

Here is my page: http://ob-kc.com/tl.html

The thumbnails are linked to their respective timelapse videos. Between the thumbnail itself and the label (i.e. '7 am - 8 am') I would like to add 'Updated x/x/2011 @ xx:xx:xx'

Any suggestions on the cleanest way to do this?

Hugh

I just recalled using date(); time() for lots of things in my database, including post times etc. At first I simply assumed this used server time or something, but when I changed my PC's time, it changed ! Now, shortly after this I simply assumed this was because of me using a localhost? But I am not certain anymore..

If I would place this online, would date() and time() return you server time or user time? I couldnt find it on google =-(

hi all,

i have a script that im trying to add the @ sign after the date.

code:
Code: [Select]
<td align='left' class='forumheader3' nowrap>".(($wardate == -1) ? "" : date($conf['formatdetails'], $wardate))."</td>
resulting in this:
Code: [Select]
1 Apr 2012 21:30
but i am trying to get the @ after the date so the result would be this:
Code: [Select]
1 Apr 2012 @ 21:30
any help please