Tags » 技术笔记

Convert excel datetime text to a sort-able standard datetime string

Here are a few excel datetime strings in format like “m/d/yyyy h:mm:ss am/pm”, so the length of this string is different in different date/time:

技术笔记

Search keyword in certain files in certain folders

Through UI in Windows:

Through git bash prompt:

  • grep -irnl "my search keyword" --include=*.js --include=*.cs /c/Windows/ /c/temp/
技术笔记

The performance summary of OUTER JOIN vs NOT IN VS NOT EXISTS

Mark this post which is extremely useful to compare performance among these SQL query WHERE methods: https://sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join

Summary in short: NOT EXISTS > EXCEPT or NOT IN > OUTER JOIN methods.

技术笔记

Oliver Sweeney’s Latest Capsule Collection Lets You Walk a Mile in Renowned Photographer Nadav Kander’s Shoes

For British brand Oliver Sweeney, shoes are much more than a mere accessory. In addition to simply expressing personal style, the house understands that the shoes a man chooses to… 339 more words

Style

She Cancelled Her Wedding And Then Gave People A Beautiful Surprise

{“contentType”:”NEWS_STORY”,”id”:{“value”:”25e2c654f0291092a2447bab71b1b9ce”,”link”:”http:\/\/api.newsapi.com.au\/content\/v2\/25e2c654f0291092a2447bab71b1b9ce”},”originId”:”Whimn-54950″,”origin”:”WORDPRESS”,”channel”:”NONE”,”title”:”She Cancelled Her Wedding And Then Gave People A Beautiful Surprise”,”altTitle”:””,”subtitle”:”She Cancelled Her Wedding And Then Gave People A Beautiful Surprise”,”description”:”

This story will give you all the feels.“,”link”:”http:\/\/cdn.newsapi.com.au\/link\/25e2c654f0291092a2447bab71b1b9ce”,”canonicalOverride”:””,”paidStatus”:”NON_PREMIUM”,”originalSource”:”whimn.com.au”,”creditedSource”:”whimn.com.au”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T22:48:32.000Z”,”dateLive”:”2017-07-16T22:20:45.000Z”,”customDate”:”2017-07-16T21:03:43.000Z”,”dateCreated”:”2017-07-16T21:13:32.000Z”,”status”:”ACTIVE”,”thumbnailImage”:{“contentType”:”IMAGE”,”id”:{“value”:”aef474e9724c20dcc745f43f8aaca07b”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/aef474e9724c20dcc745f43f8aaca07b”},”originId”:”Whimn-43420-spp_thumbnail”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/aef474e9724c20dcc745f43f8aaca07b”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”felicityharley”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:6,”format”:”jpeg”,”width”:100,”height”:75,”imageName”:”Wedding cake topper”,”imageType”:”THUMBNAIL”,”sourceImageId”:”Whimn-43420″},”related”:[{“contentType”:”IMAGE”,”id”:{“value”:”8a6be58ee17094e9ce0563653df7338f”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/8a6be58ee17094e9ce0563653df7338f”},”originId”:”Whimn-43420-major_event”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/8a6be58ee17094e9ce0563653df7338f”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:20.000Z”,”dateLive”:”2017-07-16T21:13:20.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“PRIMARY”,”SUBSTITUTE”],”format”:”jpeg”,”width”:650,”height”:366,”imageName”:”Wedding cake topper”,”imageType”:”PRIMARY”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”0e6af81848a5e6f1e4233cfa0e182110″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/0e6af81848a5e6f1e4233cfa0e182110″},”originId”:”Whimn-43420-promo_thumbnail”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/0e6af81848a5e6f1e4233cfa0e182110″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:149,”height”:86,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”f821027ad6ae9d72887b74ae4b85a340″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/f821027ad6ae9d72887b74ae4b85a340″},”originId”:”Whimn-43420-story_crop”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/f821027ad6ae9d72887b74ae4b85a340″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:316,”height”:237,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”9a7b2852d1915dbae5ca354973fbac93″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/9a7b2852d1915dbae5ca354973fbac93″},”originId”:”Whimn-43420-story_portrait”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/9a7b2852d1915dbae5ca354973fbac93″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:316,”height”:421,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”16ab3e7b8b9abc407c3b7c2c07cf4d80″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/16ab3e7b8b9abc407c3b7c2c07cf4d80″},”originId”:”Whimn-43420-tablet_wide”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/16ab3e7b8b9abc407c3b7c2c07cf4d80″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:1280,”height”:720,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”383840004b03d57177cae4ea86e50e83″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/383840004b03d57177cae4ea86e50e83″},”originId”:”Whimn-43420-tablet_thumbnail”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/383840004b03d57177cae4ea86e50e83″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:196,”height”:110,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”5ebbdbd8d2ab07f2118d5995a54b8811″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/5ebbdbd8d2ab07f2118d5995a54b8811″},”originId”:”Whimn-43420-full_width”,”origin”:”WORDPRESS”,”title”:”Wedding cake topper”,”subtitle”:”Wedding cake topper”,”description”:”Wedding cake topper”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/5ebbdbd8d2ab07f2118d5995a54b8811″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Whimn”,”creditedSource”:”Whimn”,”version”:”PUBLISHED”,”dateUpdated”:”2017-07-16T21:13:21.000Z”,”dateLive”:”2017-07-16T21:13:21.000Z”,”dateCreated”:”2017-06-07T19:51:45.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[],”authors”:[],”domains”:[],”locationGeoPoints”:[],”userOriginUpdated”:”corrinebarracloughnewscomau”,”systemOriginUpdated”:”WORDPRESS”,”domainOriginUpdated”:”Whimn”,”urlTitle”:”wedding-cake-topper”,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:1000,”height”:563,”imageName”:”Wedding cake topper”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”Whimn-43420″},{“contentType”:”IMAGE”,”id”:{“value”:”9ad0e08a494f1cb57c8f2746b452b16e”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/9ad0e08a494f1cb57c8f2746b452b16e”},”originId”:”Whimn-54951-gallery_landscape”,”origin”:”WORDPRESS”,”title”:”Sarah Cummins at the Ritz Charles. 839 more words

Strength