Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 221-230 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

223	SQLite	Strings	Strings miteinander verbinden	SELECT field_a ,field_b ,field_a \|\| field_b as together FROM table_1
224	PHP	Strings	Replace	// http://php.net/manual/de/function.str-replace.php $str1 = "abc#def"; $str1 = str_replace("#",";",$str1); echo $str1; # Output: abc;def
225	PHP	Systeminfo	Hostnamen ermitteln	echo gethostname(); // prints myComputer1 or srvLinux1
226	T-SQL	Systeminfo	Hostnamen ermitteln	SELECT HOST_NAME() AS Hostname; -- prints myComputer1 or srvWindows1
227	PowerShell	Systeminfo	Hostnamen ermitteln	$myHostname = [system.environment]::MachineName; write-host $myHostname; # prints MyComputer1 or srvWindows2
228	PowerShell	Strings	Replace	$str1 = "abc#def"; $str1 = $str1.Replace("#",";"); write-host $str1; # Output: abc;def
229	PowerShell	Strings	String nach einem Teilstring durchsuchen	# 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; }
230	MySQL	Datum, Zeit	Jahr aus Datum extrahieren	SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014
231	MySQL	Datum, Zeit	Monat aus Datum extrahieren	SELECT extract(month from now()) AS Month; SELECT extract(month from '2014-07-01') AS Month; -- 7
232	MySQL	Datum, Zeit	Datum/Uhrzeit zusammensetzen	SELECT MAKETIME(19,53,20) AS TIME; -- 19:53:20 SELECT MAKEDATE(2014,120) AS DATE; -- ^^^ -- Day of Year -- 2014-04-30