Tutorial by Examples: a

Formatting and printing date-time objects

# test date-time object options(digits.secs = 3) d = as.POSIXct("2016-08-30 14:18:30.58", tz = "UTC") format(d,"%S") # 00-61 Second as integer ## [1] "30" format(d,"%OS") # 00-60.99… Second as fractional ## [1] "30.579" for...

R Language • Date-time classes (POSIXct and POSIXlt)

Parsing strings into date-time objects

The functions for parsing a string into POSIXct and POSIXlt take similar parameters and return a similar-looking result, but there are differences in how that date-time is stored; see "Remarks." as.POSIXct("11:38", # time string format = "...

R Language • Date-time classes (POSIXct and POSIXlt)

Getting Started: Hello world!

Creating an HTML document and enabling knockout.js Create an HTML file and include knockout.js via a <script> tag. <!DOCTYPE html> <html> <head> <title>Hello world! (knockout.js)</title> </head> <body> <script src="https://cdnjs...

knockout.js • Getting started with knockout.js

Checking a single property

The quickCheck function tests a property on 100 random inputs. ghci> quickCheck prop_reverseDoesNotChangeLength +++ OK, passed 100 tests. If a property fails for some input, quickCheck prints out a counterexample. prop_reverseIsAlwaysEmpty xs = reverse xs == [] -- plainly not true for all ...

Haskell Language • QuickCheck

First Module and Hello World

To start coding in the first place, you have to right click your VBA Project in the left list and add a new Module. Your first Hello-World Code could look like this: Sub HelloWorld() MsgBox "Hello, World!" End Sub To test it, hit the Play-Button in your Toolbar or simply hit the...

VBA • Getting started with VBA

Each

Ruby has many types of enumerators but the first and most simple type of enumerator to start with is each. We will print out even or odd for each number between 1 and 10 to show how each works. Basically there are two ways to pass so called blocks. A block is a piece of code being passed which will...

Ruby Language • Iteration

Add shadows to text

Swift label1.layer.shadowOffset = CGSize(width: 3, height: 3) label1.layer.shadowOpacity = 0.7 label1.layer.shadowRadius = 2 Swift 3 label1.layer.shadowOffset = CGSize(width: 3, height: 3) label1.layer.shadowOpacity = 0.7 label1.layer.shadowRadius = 2 Objective-C label1.layer.shadowOffs...

iOS • UILabel

INSERT multiple rows of data

To insert multiple rows of data in SQL Server 2008 or later: INSERT INTO USERS VALUES (2, 'Michael', 'Blythe'), (3, 'Linda', 'Mitchell'), (4, 'Jillian', 'Carson'), (5, 'Garrett', 'Vargas'); To insert multiple rows of data in earlier versions of SQL Server, use "UNION ALL" like so: ...

Microsoft SQL Server • INSERT INTO

INSERT a single row of data

A single row of data can be inserted in two ways: INSERT INTO USERS(Id, FirstName, LastName) VALUES (1, 'Mike', 'Jones'); Or INSERT INTO USERS VALUES (1, 'Mike', 'Jones'); Note that the second insert statement only allows the values in exactly the same order as the table columns whereas in...

Microsoft SQL Server • INSERT INTO

Copying contents from one slice to another slice

If you wish to copy the contents of a slice into an initially empty slice, following steps can be taken to accomplish it- Create the source slice: var sourceSlice []interface{} = []interface{}{"Hello",5.10,"World",true} Create the destination slice, with: Length =...

Go • Slices

The Pipe Operator

The Pipe Operator |> takes the result of an expression on the left and feeds it as the first parameter to a function on the right. expression |> function Use the Pipe Operator to chain expressions together and to visually document the flow of a series of functions. Consider the following:...

Elixir Language • Operators

Basic Example

The canvas element was introduced in HTML5 for drawing graphics. <canvas id="myCanvas"> Cannot display graphic. Canvas is not supported by your browser (IE<9) </canvas> The above will create a transparent HTML<canvas> element of 300×150 px in size. You can us...

HTML • Canvas

x86 Assembly Language

The family of x86 assembly languages represents decades of advances on the original Intel 8086 architecture. In addition to there being several different dialects based on the assembler used, additional processor instructions, registers and other features have been added over the years while still r...

Intel x86 Assembly Language & Microarchitecture • Getting started with Intel x86 Assembly Language & Microarchitecture

Chaining Pipes

Pipes may be chained. <p>Today is {{ today | date:'fullDate' | uppercase}}.</p>

Angular 2 • Pipes

DECIMAL and NUMERIC

Fixed precision and scale decimal numbers. DECIMAL and NUMERIC are functionally equivalent. Syntax: DECIMAL ( precision [ , scale] ) NUMERIC ( precision [ , scale] ) Examples: SELECT CAST(123 AS DECIMAL(5,2)) --returns 123.00 SELECT CAST(12345.12 AS NUMERIC(10,5)) --returns 12345.12000

SQL • Data Types

FLOAT and REAL

Approximate-number data types for use with floating point numeric data. SELECT CAST( PI() AS FLOAT) --returns 3.14159265358979 SELECT CAST( PI() AS REAL) --returns 3.141593

SQL • Data Types

MONEY and SMALLMONEY

Data types that represent monetary or currency values. Data typeRangeStoragemoney-922,337,203,685,477.5808 to 922,337,203,685,477.58078 bytessmallmoney-214,748.3648 to 214,748.36474 bytes

SQL • Data Types

BINARY and VARBINARY

Binary data types of either fixed length or variable length. Syntax: BINARY [ ( n_bytes ) ] VARBINARY [ ( n_bytes | max ) ] n_bytes can be any number from 1 to 8000 bytes. max indicates that the maximum storage space is 2^31-1. Examples: SELECT CAST(12345 AS BINARY(10)) -- 0x0000000000000000...

SQL • Data Types

CHAR and VARCHAR

String data types of either fixed length or variable length. Syntax: CHAR [ ( n_chars ) ] VARCHAR [ ( n_chars ) ] Examples: SELECT CAST('ABC' AS CHAR(10)) -- 'ABC ' (padded with spaces on the right) SELECT CAST('ABC' AS VARCHAR(10)) -- 'ABC' (no padding due to variable character) SELE...

SQL • Data Types

NCHAR and NVARCHAR

UNICODE string data types of either fixed length or variable length. Syntax: NCHAR [ ( n_chars ) ] NVARCHAR [ ( n_chars | MAX ) ] Use MAX for very long strings that may exceed 8000 characters.

SQL • Data Types