Welcome to Programmers Language v2

ID: 223
PlCodelang: SQLite
PlGroup: Strings
PlItemTitle: Strings miteinander verbinden
Code: SELECT field_a ,field_b ,field_a || field_b as together FROM table_1

ID: 224
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Replace
Code: // http://php.net/manual/de/function.str-replace.php $str1 = "abc#def"; $str1 = str_replace("#",";",$str1); echo $str1; # Output: abc;def

ID: 225
PlCodelang: PHP
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: echo gethostname(); // prints myComputer1 or srvLinux1

ID: 226
PlCodelang: T-SQL
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: SELECT HOST_NAME() AS Hostname; -- prints myComputer1 or srvWindows1

ID: 227
PlCodelang: PowerShell
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: $myHostname = [system.environment]::MachineName; write-host $myHostname; # prints MyComputer1 or srvWindows2

ID: 228
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: Replace
Code: $str1 = "abc#def"; $str1 = $str1.Replace("#",";"); write-host $str1; # Output: abc;def

ID: 229
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: # See also a good hint with explanation between like and contains: # http://windowsitpro.com/blog/powershell-contains $fullstring = "This is my string"; if ($fullstring -like "*my*") { Write-Host "found" -ForegroundColor Green; } else { Write-Host "nope" -ForegroundColor Red; }

ID: 230
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014

ID: 231
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Monat aus Datum extrahieren
Code: SELECT extract(month from now()) AS Month; SELECT extract(month from '2014-07-01') AS Month; -- 7

ID: 232
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit zusammensetzen
Code: SELECT MAKETIME(19,53,20) AS TIME; -- 19:53:20 SELECT MAKEDATE(2014,120) AS DATE; -- ^^^ -- Day of Year -- 2014-04-30