Use the INTERVAL type to it. E.g: –yesterday SELECT NOW() – INTERVAL ‘1 DAY’; –Unrelated: PostgreSQL also supports some interesting shortcuts: SELECT ‘yesterday’::TIMESTAMP, ‘tomorrow’::TIMESTAMP, ‘allballs’::TIME AS aka_midnight; You can do the following then: SELECT org_id, count(accounts) AS COUNT, ((date_at) – INTERVAL ‘1 DAY’) AS dateat FROM sourcetable WHERE date_at <= now() – INTERVAL ‘130 DAYS’ … Read more
Use DateTime.ParseExact. this.Text=”22/11/2009″; DateTime date = DateTime.ParseExact(this.Text, “dd/MM/yyyy”, null);
You can convert Float to Int in Swift like this: var myIntValue:Int = Int(myFloatValue) println “My value is \(myIntValue)” You can also achieve this result with @paulm’s comment: var myIntValue = Int(myFloatValue)
The opposite of read is show. Prelude> show 3 “3” Prelude> read $ show 3 :: Int 3
“Casting” is different than conversion. In this case, window.location.hash will auto-convert a number to a string. But to avoid a TypeScript compile error, you can do the string conversion yourself: window.location.hash = “”+page_number; window.location.hash = String(page_number); These conversions are ideal if you don’t want an error to be thrown when page_number is null or undefined. … Read more
Note that there is a difference between a cast to long and a cast to Long. If you cast to long (a primitive value) then it should be automatically boxed to a Long (the reference type that wraps it). You could alternatively use new to create an instance of Long, initializing it with the int … Read more
I’ve just set up a quick benchmarking exercise: Function time to run 1 million iterations ——————————————– (int) “123”: 0.55029 intval(“123”): 1.0115 (183%) (int) “0”: 0.42461 intval(“0”): 0.95683 (225%) (int) int: 0.1502 intval(int): 0.65716 (438%) (int) array(“a”, “b”): 0.91264 intval(array(“a”, “b”)): 1.47681 (162%) (int) “hello”: 0.42208 intval(“hello”): 0.93678 (222%) On average, calling intval() is two and … Read more
If you’re sure that this object is an Integer : int i = (Integer) object; Or, starting from Java 7, you can equivalently write: int i = (int) object; Beware, it can throw a ClassCastException if your object isn’t an Integer and a NullPointerException if your object is null. This way you assume that your … Read more
C++ style casts are checked by the compiler. C style casts aren’t and can fail at runtime. Also, c++ style casts can be searched for easily, whereas it’s really hard to search for c style casts. Another big benefit is that the 4 different C++ style casts express the intent of the programmer more clearly. … Read more
You can cast like this: return this.createMarkerStyle(<MarkerSymbolInfo> symbolInfo); Or like this if you want to be compatible with tsx mode: return this.createMarkerStyle(symbolInfo as MarkerSymbolInfo); Just remember that this is a compile-time cast, and not a runtime cast.