UNIX Mktime To MySQL Date Or Date
A form that sends a starting date and an ending date. I have figured out how to tell the difference between the two and even rip the difference into an array because I need to compare the individual dates against a mySQL database to pull results from a particular date in a series. This is no problem. My problem is that teh mySQL database uses DATE as a field definition and this can not be changed. I managed to pull the date differences using some cleaver mktime stuff but no I do not know how to get this 1072242000 into this 2003-12-24...
Is there a function that reverses the mktime result into a usable date format? I would take anything at this point and I can explode and then array it to get what I want - but there has to be something. Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Date Conversions ( Date, Mktime )
I have a date in three pieces dd mm yyyy. I'm just wondering the best way to convert this for inserting into a DATETIME field and then back again when displaying it. I have tried date, strtotime mktime but it keeps inserting a blank date. i.e. 00:00:00 00:00... I've been looking through the php manual but I can't seem to get this working. Also would I be better off using the UNIX_TIMESTAMP function?
View Replies !
Unix Date Stamp Convert To UK Date
How do I go about converting the Unix date stamp to UK date/month/year. I know how to get the date from the database, I just need to know how I can convert this date using a php script to convert this to UK date format and display on my php page.
View Replies !
Mktime() And Date()
My users submit the date in format mm/dd/yyy via post, and I then want to display in a particular format using the date() and mktime() functions. //format class dates $classdate[0] = $_POST['classyear']; $classdate[1] = $_POST['classmonth']; $classdate[2] = $_POST['classday']; $classdate = implode("-",$classdate); $classdateDisplay= date('F d, Y', mktime(0,0,0,$classdate[1],$classdate[2],$classdate[0])); echo "debug: $classdate = $classdate<br />"; echo "debug: $classdateDisplay = $classdateDisplay<br />"; When I enter the values 2008/01/01 in the form, $classdate then correctly is displayed as 2008-01-01. But when I echo $classdateDisplay, it displays "December 3, 2001." I'm following the formatting as described http://us.php.net/mktime (here), which is: int mktime ( [int $hour [, int $minute [, int $second [, int $month [, int $day [, int $year [, int $is_dst]]]]]]] ) What am I missing here?
View Replies !
Date And Mktime()
I am having a prob inserting a timestamp into database. My form passes a manually entered date in this format dd-mm-yy (eg 01-02-06). I then use this code to seperate the date, month and year; PHP Code: $date = explode("-", $date); Â Â Â Â $date = mktime(0,0,0,$date[1],$date[0],$date[2]); Problem is that the timestamp doesnt seem to change, no matter what date i input, it stores in the database as 8388607.
View Replies !
Date() And Mktime() Output Mar Instead Of Feb
I'm getting a wierd result using the date function along with mktime. here's my code: echo date('M', mktime(0,0,0,2));Looks simple enough.. For some reason though it outputs 'Mar', but march is the third month. If I switch the 2 with 3 it outputs 'Mar'. All the other months come out correctly, just feb comes out as 'Mar' and I can't figure it out...
View Replies !
Date Manipulation - Mktime
I have created 2 pages to query a database. There are 2 bits of date manipulation with which I am having a problem: Last Week and Last Month - when the user clicks Last week, I need a string produced. If today is 05/05/2007, the string I need produced is "29/04/2007...04/05/2007" which is the last 7 days. If the user clicks Last Month, I need just the number produced, so if this month is May, I need 4 produced. I have tried all sorts of stuff with mktime, but it just produces rubbish, here is an example of my code:
View Replies !
Problem With Date() And Mktime()
I have a php mailing list script written by someone i can't remember but its a good script so thanks. The problem is that when I send mail out it does not reach aol or lycos users. Is this because they see this as spamming? I changed the from bit to a valid email address but it still doesnt work. Does the mail function need any extra parameters to show its not spam if that is the problem.
View Replies !
Strange Problem With Mktime And Date
I have a strange problem with mktime and date: date("D-d-M-Y",mktime(0,0,0,4,1,2001)); returns Sun-01-Apr-2001 date("D-d-M-Y",mktime(0,0,0,4,2,2001)); returns Thu-29-Mar-2001 date("D-d-M-Y",mktime(0,0,0,4,3,2001)); returns Fri-30-Mar-2001 date("D-d-M-Y",mktime(0,0,0,4,4,2001)); returns Sat-31-Mar-2001 date("D-d-M-Y",mktime(0,0,0,4,5,2001)); returns Thu-05-Apr-2001 Can someone explain me?
View Replies !
Date Calculation Problem W/ Mktime()
I am having a problem with calculating a date. What I am looking to do is get the date of Sunday of this week, then use mktime() to find out other days in the past by subtracting days. In the code below, today is Saturday, October 16, 2004, this week's Sunday is 2004-10-17. I successfully get that. But, when I try to subtract 7 days using mktime(), I instead of getting 2004-10-10, I get 1969-12-31. I have looked through php.net/mktime and searched some example via Google, but I stuck. Any help would be greatly appreciated. CODE BELOW: $today = unixtojd(); // GET THIS WEEK'S SUNDAY $this_sunday = $today + (7 - jddayofweek($today)) % 7; $current_sunday = jdtogregorian($this_sunday); $this_sundays_parts = explode("/",$current_sunday); $cur_sunday = $this_sundays_parts[2] . "-" . $this_sundays_parts[0] . "-" . $this_sundays_parts[1]; // GET LAST WEEK'S SUNDAY $last_sunday = date("Y-m-d", mktime(0, 0, 0, date($this_sundays_parts[2]), date($this_sundays_parts[0]), date($this_sundays_parts[1])-7)); // PRINT OUT THE DATES print "This Sunday is " . $cur_sunday . "<BR>"; print "Last Sunday was " . $last_sunday . "<BR>";
View Replies !
Date And Mktime Function Usage?
How come its not printing out the right date output. where I am making mistakes. PHP Code: $tomorrow = mktime(0.0,0, date("m") , date("d")+1, date("Y")); $lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y")); $nextyear = mktime(0, 0, 0, date("m"), date("d"), date("Y")+1); echo "$tomorrow<BR>"; echo "$lastmonth<BR>"; echo "$nextyear<BR>"; output: 1280289612 1100322000 1134450000
View Replies !
UNIX Timestamp To Date
I looked in the forums little and in the php manual but I didn't find what I wanted. I want to know how I could change a unix timestamp into a normal date such as MMDDYYYY.
View Replies !
Date To Unix Timestamp
I am getting a date and time from a user. The send in a date with the format dd-mm-yyyy and a time with format hh:mm and then send in whether it is am or pm. now i split the date and time, then try to figure out the hour using: Code:
View Replies !
SQL Date/time Or Unix Timestamp?
Generally when developing applications I use unix timestamps as the method of storing dates in a sql database. However, I was wondering if I should use the standard date-time used by the database. The question then arises: continue using PHP to manipulate the dates, or allow the sql server to take over. Can anyone provide any reasons to use sql date-time rather than unix timestamps?
View Replies !
Textual Date To Unix Timestap
Is there an easy way to take a date and convert it to a time stamp. In the format of September 12, 2001 - 05:00 pm I know I can explode it and so forth, but is their easier.
View Replies !
Converting A Date To Unix Timestamp
I have a form where people enter their birthday_day, birthday_month, and birthday_year Is there a way to do the following; convert_this_to_unix_timestamp($_POST['birthday_day'], $_POST['birthday_month'], $_POST['birthday_year']); The point is that if i store it as a unix_timestamp, then i can do some math on it and return the users age instead of their birthday.
View Replies !
Date Is Not Being Pulled From MYSQL Database, Instead Current Date Is Displayed!
I am having trouble pulling a date from a database using PHP at the <a href="http://www.mytuneslive.com/ameshkin69/"> following page.</a> Here is the code. As you can see, it is just making the date the current time. The values in the database are UNIX timestamp, and the DATE() function is used to convert from UNIX to readable date. Can <td width="55%" align="left" valign="top"><?php $row_comment['timestamp'] = date("n d Y g:i A");.....
View Replies !
Store Date In A Date Field In My MYSQL Data Table
I have a form with a feild that when clicked on pops up a calendar which I can select a date I wnat to insert into the field. The date inserted displays "03 Apr, 2007". I want to store that date in a date field in my MYSQL data table, a field named "f_date" set to date type. When I save the record the data field "f_date" displays "0000-00-00" which I take it the date input is not getting inserted to the table. My insert field code is PHP Code: <input name="f_date"Â Â type="text" class="bodytext" id="f_date" onclick='scwShow(this,this);' value="" size="15" />
View Replies !
Convert Date String To Unix Time
Basically I wrote a little script that captured the date as a string like "July 3, 2007". Well, now I'd like to take all the information recorded and put it into another database as unix time (I'm wanting to migrate my personally written scripts into a more robust pre-written forum script). I think I need to use mktime(), but I'm not sure how to convert the string date above into something useable for mktime(). Any ideas?
View Replies !
Unix Timestamp Into Textual Date Time
How do i convert a Unix timestamp into English textual date time description? In my database i have stored the date and time as 1187079740 and now i want it to be converted into 14/08/2007 13:52:20. I have currently used <?php $format = '%d/%m/%Y %H:%M:%S' $strf = strftime($format); echo "$strf "; print_r(strptime($strf, $format)); ?> I am generating data from a db to xml which gives date as <date>1187079740</date> Now my task is to convert SPECIFICALLY the value 1187079740 into it's actual textual form of 14/08/2007 13:52:20. I want the data 1187079740 to be written into a php script to generate it's textual time.
View Replies !
Date Dropdown From Mysql Date Entries
For the PHP gurus out there, here is what I want to do: create a dropdown list of available dates from a mysql database date entries. But the dropdown/s should have 3 separate fields in month, day and year which in effect shows only those months, days and years that have corresponding entries from the database. Planning to use this in the archive section of an online news publication so people can select issues to view via dropdown list that have corresponding entries only.
View Replies !
Convert Date To A MySQL Acceptable Date
I've got a date that looks like this: 06/08/2007 AM I'm trying to convert it to a MySQL acceptable date so it can be inserted into the data and read as normal MySQL dates would read so I can use my date searching functions. I use a lot of -30 days searches and stuff like that. As I insert the records into the database (which come in from a .csv file) the "SCHEDULED_DATE" looks like that above but that, as we all know, won't work with things like 'SCHEDULED_DATE > $onemonth' ($onemonth being a date that is a month ago). So while the records are imported I have been trying to take that date and convert it into a usable MySQL date. Although my attempts have completely failed. Here is one of the newest things I have used, which didn't work and I really don't know why. Code:
View Replies !
Convert Input Date To Mysql Date
Wanted to see if there was a cleaner way to do this. My form takes a user-input date in the format MM/DD/YYYY. I need to convert that to YYYY-MM-DD to query against my database. The code below works, but basically I take input dates convert them to a UNIX timestamp with strtotime() and then convert them back to the format I need using strftime() PHP Code: $format = '%Y-%m-%d' $startDate =Â Â strtotime($startDate); $startDate = strftime($format, $startDate); $endDate =Â Â strtotime($endDate); $endDate = strftime($format, $endDate);
View Replies !
How To Convert Uk Date To Mysql Date Format
how to convert uk date to mysql date format? I have 3 textboxes having the values of dates. the format are the following: textbox1-29/08/2007 textbox2-14/08/2007 textbox3-20/08/2007 upon entering it into the database the following dates should be converted already to the mysql date format like 2007-08-29
View Replies !
Convert User Entered Date And Time To Unix Timestamp Before Inserting To Database
How do you convert a user inputted date to a unix timestamp before insterting it into your database? I have a form, with a textfield for a date that the user inputs in the format mm-dd-yyyy and three dropdow boxes for hours, minutes, and AM/PM. All of these need to be considered together and converted to one Unix Timestamp and then inserted to the MYSQL date field. The type of field is INT (11) so that I can instead of the standard 0000-00-00 format of MYSQL so that I can do better calculations and queries.
View Replies !
Get The Todays Date- Yesterdays Date And Tomorrows Date
I get the todays date- yesterdays date and tomorrows date, like so: $yesterday = date ("Y-m-d", mktime (0,0,0,date("m"),(date("d")-1),date("Y"))); $tomorrow = date ("Y-m-d", mktime (0,0,0,date("m"),(date("d")+1),date("Y"))); $actualdate = date("Y-m-d"); Which returns the date in the format "200-11-13" But I need to add 13 hours to all three - how owuld I do this?
View Replies !
Put Today's Date Into A MySQL "date" Formated Field
My MySQL table has a field that is set as type "date." I need to get today's date, and insert it into that field. The default for that MySQL field is 2006-00-00. I know about the date() function. I have tried date("Y-m-d") and date("U"), neither worked. The date field was just filed with all zeros. Can anybody point me in the right direction?
View Replies !
Check Date From Input Must Greater Or Equal Today Date?
I have 3 select box. Code: <select name="day"> <option value="1">1</option> <option value="2">2</option> ....... <option value="31">31</option> </select> <select name="month"> <option value="01"> Jan </option> <option value="02"> Feb </option> ..... </select> <select name="year"> <option value="2002">2002 </option> <option value="2003">2003</option> </select> When I select and click submit in form. I will have 3 variable : $day, $month and $year How can I check the day that I choose in form must equal or greater than today date? If it less than today date. I must print error message to user.
View Replies !
Date() Question - Minus One Day Of The Return Date Choose By User
I have a date function, that gets today's date. Then my user can choose a date for the return date. I need to minus one day of the return date for a date_flag , but having trouble. PHP Code: <? $date_book = date("Y-m-d H:i:s"); $date_return = $_POST['date_return']; //Returns a date like this 2007-05-25                          // needs to be date_return - 1 day like 2007-05-24 $date_flag  = mktime(date("Y", $date_return), date("m", $date_return), date("d", $date_return)-1); ?>
View Replies !
Read Today's Date Print Tomorrow's Date
I've got a small script that writes a random number and the date to a text file. Then the script opens this text file and if date = date from this text file something must happen. If something happened this script must open this text file again and replace it with a new random number and tomorrow's date. <?php $date = date("d-m-Y"); mt_srand((double)microtime()*10000000000); $num=mt_rand(0, 20); if ($num == $num && $date == "$tomorrowdate") { echo"$num -- $date";} else echo " ";?> So if the script gets activated on the 05-05-2003 it must write tomorrow's date into the text file (06-05-2003). How will I get tomorrow's date today?
View Replies !
Date Validation - Date In String Format
i have got an date in string format ddmmyyyy (eg: 15052007).i have to validate this date. i have alrady validate this date for a number. now all i have to do is check the day (dd) against month (mm). example, 29 feb is invalid date, if not a leap year.i have tried to wrote some bit of code but still struggling with it.
View Replies !
Save Date To Table Field Date Type
I have a calendar picker on a form that fills a text box with XX/XX/XXXX date format. If I run a insert statement the date field in the database shows 0000-00-00. If i change the field type to varchar the correct format displays. What is the correct way to save a date to a mysql database? Furthermore to query on the date how about a select * from db_name where servicedate >= $startdate and servicedate >= $enddate I supose this will not work Any pointers?
View Replies !
Start Date - End Date = Number Of Days
I have a starting date for var 1 and today’s date for var 2. I need to calculate how many days are between those two dates. 02/24/03(today) - 01/14/2002(start date) = number of days. In theory this is easy but there are many instances were I could get an inaccurate answer. For example one consideration is that some months have 30 days others have 31. exc. My question is, is there an easier way to solve this problem other than using endless if statments to error handle all possible instances? Does PHP4 have any built in functions that could calculate this formula correctly?
View Replies !
Counting Days From $date To Current Date
how to count the time between two variable dates? Such as someone inputting 6/8/1991 in a form and it comparing that to todays date... then getting the number of seconds elapsed... I know I have to use the mktime() function to get the seconds.. but not quite sure how.
View Replies !
Date Comparison - Checks If A Date Is In Between Two Other Dates
I'm having trouble writing a program that checks if a date is in between two other dates or not. $today = date("d-m-y"); $a = "09-09-06"; //September 9th, 2006 $c = "09-09-09"; //September 9th, 2009 if($a <= $today && $today<$c){ echo "Wee";} else{ echo "Wrong";} When I try outputting this, it outputs always outputs "Wrong" for some reason, although $today is clearly inbetween $a and $c (Sept.09'06 and Sept.09'09). Am I doing something wrong?
View Replies !
Compare Date Of Today And The Date In The Database
i have a db that stores a date in a table with a specific column. db=test table=test_date_compare column name=date_inserted ok i hv a php form that allows user to input date and it enters in the above column (date) as in format eg: 21/03/2007 now i wat i would like to do is i would like to compare date of today and the date in the database if it is lesser then todays date it deletes that row of data. deleting the row of data i know how but the problem comes wen coparing the date i dunno how to ...
View Replies !
Convert The Date Separator Before Inserting The Date Into The DB
I need to convert the date separator before inserting the date into the DB. Right now, I have 01/01/2006 and I want 01-01-2006. The dates are coming from a CSV and so are an array element. I've tried strrpos and a few other functions trying to just replace the slashes with hypens and that's not working (I think maybe because it's an array and those functions don't work on arrays?) Could someone post example code for something like this? I have an array called $items[3] that holds the date with the separator mentioned above. I'm sure there are several ways to do it in both php and with mysql functions but I've been stuck on it for a while and REALLY need to get through this for a project I'm working on right now.
View Replies !
Converting Database Date To Normal Date
I am looking for a way to convert a date that is stored in a MySQL database like this after useing the date() function in PHP: 2006-08-16 21:03:54 and convert it into a date this: 16 August 2006 @ 11:03:54pm Does anyone have some insight as to how I would go about doing that?
View Replies !
|
TRACKER
