A fast but sometimes-unreliable solution: $date=”2011-09-02T18:00:00″; $time = strtotime($date); $fixed = date(‘l, F jS Y \a\t g:ia’, $time); // ‘a’ and ‘t’ are escaped as they are a format char. Format characters detailed here.
Ok, so I think I have figured this all out now thanks to more reading, experimenting and the other helpful answers here. What’s happening is that H, m and s actually grabs two digits when they can, even if there won’t be enough digits for the rest of the format. So for example with the … Read more
I came across this thread today, and after further digging found that Pandas .15 affords an easier option use .dt, you can avoid the step of creating an index and create the column directly. You can use the following to get the same result: df[1] = df[0].dt.to_period(‘M’)
There’s a Java 8 library here: https://github.com/gkopff/gson-javatime-serialisers Here’s the Maven details (check central for the latest version): <dependency> <groupId>com.fatboyindustrial.gson-javatime-serialisers</groupId> <artifactId>gson-javatime-serialisers</artifactId> <version>1.1.1</version> </dependency> And here’s a quick example of how you drive it: Gson gson = Converters.registerOffsetDateTime(new GsonBuilder()).create(); SomeContainerObject original = new SomeContainerObject(OffsetDateTime.now()); String json = gson.toJson(original); SomeContainerObject reconstituted = gson.fromJson(json, SomeContainerObject.class);
You can use the STUFF() method to insert characters into your string to format it in to a value SQL Server will be able to understand: DECLARE @datestring NVARCHAR(20) = ‘20120225143620’ — desired format: ‘20120225 14:36:20′ SET @datestring = STUFF(STUFF(STUFF(@datestring,13,0,’:’),11,0,’:’),9,0,’ ‘) SELECT CONVERT(DATETIME, @datestring) AS FormattedDate Output: FormattedDate ======================= 2012-02-25 14:36:20.000 This approach will work … Read more
You could use a try/except block: try: timestamp = datetime.strptime(date_string, ‘%Y-%m-%d %H:%M:%S.%f’) except ValueError: timestamp = datetime.strptime(date_string, ‘%Y-%m-%d %H:%M:%S’)
It’s been asked on the mailing list and the answer is that it is not possible because the original pattern is not retained. The same thread suggests using a DateTimeFormatterBuilder which does have the information.
Use DateTime.ParseExact, e.g.: DateTime.ParseExact(“12/02/21 10:56:09”, “yy/MM/dd HH:mm:ss”, CultureInfo.InvariantCulture ).ToString(“MMM. dd, yyyy HH:mm:ss”)
Object Oriented This is the recommended way. $datetime = new DateTime(‘2010-12-30 23:21:46’); echo $datetime->format(DateTime::ATOM); // Updated ISO8601 Procedural For older versions of PHP, or if you are more comfortable with procedural code. echo date(DATE_ISO8601, strtotime(‘2010-12-30 23:21:46’));
I hope this helps. I’ve always had a hard time with matplotlib’s dates. Matplotlib requires a float format which is days since epoch. The helper functions num2date and date2num along with python builtin datetime can be used to convert to/from. The formatting business was lifted from this example. You can change an axis on any … Read more