I would like to check, if a date is today, tomorrow, yesterday or else. But my code doesn’t work. Code: $timestamp = “2014.09.02T13:34”; $date = date(“d.m.Y H:i”); $match_date = date(‘d.m.Y H:i’, strtotime($timestamp)); if($date == $match_date) { //Today } elseif(strtotime(“-1 day”, $date) == $match_date) { //Yesterday } elseif(strtotime(“+1 day”, $date) == $match_date) { //Tomorrow } else … Read more
I’ve been searching for 4 hours now, and have not found a solution to get the difference between two dates in years, months, and days in JavaScript, like: 10th of April 2010 was 3 years, x month and y days ago. There are lots of solutions, but they only offer the difference in the format … Read more
Using a Python script, I need to read a CVS file where dates are formated as DD/MM/YYYY, and convert them to YYYY-MM-DD before saving this into a SQLite database. This almost works, but fails because I don’t provide time: from datetime import datetime lastconnection = datetime.strptime(“21/12/2008”, “%Y-%m-%d”) #ValueError: time data did not match format: data=21/12/2008 … Read more
Why does this work? date_default_timezone_set(‘Australia/Currie’); But this doesn’t seem to take any effect at all? date_default_timezone_set(‘UTC’); This value doesn’t change when setting the timezone to UTC: echo date(‘Y-m-d H:i:s’, time()); I’m using php 5.2.13, and the timezone of my server is: $server_tz = date_default_timezone_get(); echo $server_tz; //outputs ‘America/Guayaquil’ This is the original code: echo time() … Read more
I have a date in R, e.g.: dt = as.Date(‘2010/03/17’) I would like to subtract 2 years from this date, without worrying about leap years and such issues, getting as.Date(‘2010-03-17’). How would I do that? Answer With lubridate library(lubridate) ymd(“2010/03/17”) – years(2) AttributionSource : Link , Question Author : gt6989b , Answer Author : hadley
I need to select data from MySQL database between the 1st day of the current month and current day. select*from table_name where date between “1st day of current month” and “current day” Can someone provide working example of this query? Answer select * from table_name where (date between DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), interval 30 day), interval 1 day) … Read more
How do I extract the month and date from a mySQL date and compare it to another date? I found this MONTH() but it only gets the month. I looking for month and year. Answer in Mysql Doku: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_extract SELECT EXTRACT( YEAR_MONTH FROM `date` ) FROM `Table` WHERE Condition = ‘Condition’; AttributionSource : Link , … Read more
I made new object Date.new with args (year, month). After create ruby added 01 number of day to this object by default. Is there any way to add not first day, but last day of month that i passed as arg(e.g. 28 if it will be 02month or 31 if it will be 01month) ? … Read more
<?php $date = “04-15-2013”; $date = strtotime($date); $date = strtotime(“+1 day”, $date); echo date(‘m-d-Y’, $date); ?> This is driving me crazy and seems so simple. I’m pretty new to PHP, but I can’t figure this out. The echo returns 01-01-1970. The $date will be coming from a POST in the format m-d-Y, I need to … Read more
I’m sure there’s a good simple elegant one-liner in Ruby to give you the number of days in a given month, accounting for year, such as “February 1997”. What is it? Answer If you’re working in Rails, chances are you’ll get hamstrung eventually if you switch among Time, Date, and DateTime, especially when it comes … Read more
