SELECT
date('now') AS [Today],
datetime(strftime('%s','now'), 'unixepoch') AS [Now_UTC],
datetime(strftime('%s','now'), 'unixepoch', 'localtime') AS [Now_Local],
strftime('%s','now') AS [Now_EPOCH],
CAST((julianday('now') - 2440587.5)*86400000 AS INTEGER) AS [Now_EPOCH_Ms],
date('now','start of month','+1 month','-1 day') AS [LastDayOfCurrentMonth],
CAST(strftime('%s', '2019-02-07') AS INTEGER) * 1000 AS [GivenDate_EPOCH_Ms],
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
table>tr>td | |
<table> | |
<tr> | |
<td></td> | |
</tr> | |
</table> | |
ul>li*3>lorem | |
<ul> | |
<li>Tincidunt integer eu augue augue nunc elit dolor, luctus placerat scelerisque euismod, iaculis eu lacus nunc mi elit, vehicula ut laoreet ac, aliquam sit amet justo nunc tempor, metus vel.</li> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Animation timing functions | |
* ease: Slow start, then fast, then end slowly (default) | |
* linear: The same speed from start to end | |
* ease-in: With a slow start | |
* ease-out: With a slow end | |
* ease-in-out: With a slow start and end | |
* cubic-bezier(n,n,n,n): Lets you define your own values in a cubic-bezier function | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- CTRL + R | Toggle Results window. | |
-- CTRL + SHIFT + U | Upper case selected query | |
SELECT FirstName + ' ' + LastName AS 'Full_Name' | |
FROM Customer; | |
-- using Chinook database: https://chinookdatabase.codeplex.com/ | |
SELECT i.InvoiceId, InvoiceDate, UnitPrice, Quantity | |
FROM Invoice i | |
INNER JOIN InvoiceLine il ON il.InvoiceId = i.InvoiceId; |
Functions
// a function declaration accepting a number and returning a string.
let someFunc: (age: number) => string;
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
private void Flatten(JToken token, IDictionary<string, JValue> output, string prefix = "") | |
{ | |
if (token is JObject jObj) | |
{ | |
foreach(var item in token) | |
{ | |
Flatten(item, output, prefix); | |
} | |
} else if (token is JArray jArr) | |
{ |
OlderNewer