How to set the time in MS since 1970 to a Datetime(6) field in MySQL

php,mysql,datetime,datetime-format,date-manipulation

use in mysql: from_unixtime($yourvariable / 1000) Mysql timestamps are not in ms , but in seconds....

iOS detect if date is within last week

ios,nsdate,date-comparison,date-manipulation

-(BOOL) dayOccuredDuringLast7Days { NSDate *now = [NSDate date]; // now NSDate *today; [[NSCalendar currentCalendar] rangeOfUnit:NSDayCalendarUnit // beginning of this day startDate:&today // save it here interval:NULL forDate:now]; NSDateComponents *comp = [[NSDateComponents alloc] init]; comp.day = -7; // lets go 7 days back from today NSDate * oneWeekBefore = [[NSCalendar currentCalendar]...

What is the cleanest way to strip leading 0s from the day-of-month portion of dates?

c#,datetime,text-parsing,date-math,date-manipulation

Use a custom format. (MMMM d, yyyy) String lds = computedDate.ToString("MMMM d, yyyy", CultureInfo.InvariantCulture); single d would give you a single or double digit day part. If the day part is below 10, then you will get only a single digit instead of leading 0, for others you will get...