In order to be independent of the language and locale settings, you should use the ISO 8601 YYYYMMDD format – this will work on any SQL Server system with any language and regional setting in effect: SELECT CAST( CAST(year AS VARCHAR(4)) + RIGHT(‘0’ + CAST(month AS VARCHAR(2)), 2) + RIGHT(‘0’ + CAST(day AS VARCHAR(2)), 2) … Read more
Try this: import datetime d = [’09-2012′, ’04-2007′, ’11-2012′, ’05-2013′, ’12-2006′, ’05-2006′, ’08-2007′] sorted(d, key=lambda x: datetime.datetime.strptime(x, ‘%m-%Y’))
This is a known limitation with JSON. This answer might help you, specifically: value = new Date(parseInt(value.replace(“/Date(“, “”).replace(“)/”,””), 10));
What you’re looking for is this: $triggerOn = ’04/01/2013 03:08 PM’; $user_tz = ‘America/Los_Angeles’; echo $triggerOn; // echoes 04/01/2013 03:08 PM $schedule_date = new DateTime($triggerOn, new DateTimeZone($user_tz) ); $schedule_date->setTimeZone(new DateTimeZone(‘UTC’)); $triggerOn = $schedule_date->format(‘Y-m-d H:i:s’); echo $triggerOn; // echoes 2013-04-01 22:08:00
Is it possible that the date could actually be outside that range? Does it come from user input? If the answer to either of these questions is yes, then you should always check – otherwise you’re leaving your application prone to error. You can format your date for inclusion in an SQL statement rather easily: … Read more
If you’re using the DateTime module, you can call the epoch() method on a DateTime object, since that’s what you think of as unix time. Using DateTimes allows you to convert fairly easily from epoch, to date objects. Alternativly, localtime and gmtime will convert an epoch into an array containing day month and year, and … Read more
DateTime in .NET is initialized to 0001-01-01 00:00:00 and then you add your TimeSpan, which seems to be 45 Years. It is common for such (milli)-second time definitions to start at 1970-01-01 00:00:00, so maybe the following gives you the expected result: double ticks = double.Parse(startdatetime); TimeSpan time = TimeSpan.FromMilliseconds(ticks); DateTime startdate = new DateTime(1970, … Read more
I see mainly three ways: a) built-in options using SimpleDateFormat and DateUtils SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd’T’HH:mm:ss.SSS’Z'”); sdf.setTimeZone(TimeZone.getTimeZone(“GMT”)); try { long time = sdf.parse(“2016-01-24T16:00:00.000Z”).getTime(); long now = System.currentTimeMillis(); CharSequence ago = DateUtils.getRelativeTimeSpanString(time, now, DateUtils.MINUTE_IN_MILLIS); } catch (ParseException e) { e.printStackTrace(); } b) external library ocpsoft/PrettyTime (based on java.util.Date) Here you have to use SimpleDateFormat, too, … Read more
TimeSpan is the object you need: TimeSpan span = (DateTime.Now – DateTime.Now); String.Format(“{0} days, {1} hours, {2} minutes, {3} seconds”, span.Days, span.Hours, span.Minutes, span.Seconds);
If you are using MySQL you can do it like this: SELECT ‘2008-12-31 23:59:59’ + INTERVAL 30 MINUTE; For a pure PHP solution use strtotime strtotime(‘+ 30 minute’,$yourdate);