Welcome to Programmers Language v2

ID: 233
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit berechnen
Code: SELECT DATE_ADD(now(),INTERVAL -45 DAY) AS calculated_Day; -- ^^^ -- Type -- -- Available Types: -- MICROSECOND -- SECOND -- MINUTE -- HOUR -- DAY -- WEEK -- MONTH -- QUARTER -- YEAR -- SECOND_MICROSECOND -- MINUTE_MICROSECOND -- MINUTE_SECOND -- HOUR_MICROSECOND -- HOUR_SECOND -- HOUR_MINUTE -- DAY_MICROSECOND -- DAY_SECOND -- DAY_MINUTE -- DAY_HOUR -- YEAR_MONTH

ID: 234
PlCodelang: PowerShell
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: $myDate=Get-Date -format "yyyy-MM-dd hh:mm"; write-host $myDate -Foregroundcolor Cyan; # 2014-01-14 10:15 # Maybe AM or PM # For 24h Version $myDate=Get-Date -format "yyyy-MM-dd HH:mm"; write-host $myDate -Foregroundcolor Cyan; # 2014-01-14 22:15

ID: 235
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Aktuellen Datenbanknamen ausgeben
Code: SELECT DATABASE() AS DB_Name;

ID: 236
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: -- Not a real solution, but a workaround if you have rights to create a function -- see: http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/ -- same problem with MSSQL. CREATE FUNCTION SPLIT_STR( StringToBeSplitted VARCHAR(255), delimiter VARCHAR(12), position INT ) RETURNS VARCHAR(255) RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position), LENGTH(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position -1)) + 1), delimiter, ''); SELECT SPLIT_STR(string, delimiter, position);

ID: 237
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: SELECT myString ,locate('#',myString,5) AS findPosition -- Result is: 8 ,left(myString,locate('#',myString,2)-1) AS ExtractedString -- Result is: abc ,left(myString,locate('#',myString,5)) AS ExtractedString -- Result is: abc#def# FROM ( SELECT 'abc#def#ghj' AS myString ) dummyString

ID: 238
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: String auf Wunschlänge zuschneiden
Code: // http://php.net/manual/de/function.substr.php $myString = "Benzinverbrauch"; echo substr($myString,2,8); //Ausgabe: "nzinverb"

ID: 239
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: //http://us2.php.net/manual/de/function.strtoupper.php $myString = "my lovely Mr Singing Club"; echo strtoupper($myString); // MY LOVELY MR SINGING CLUB //http://php.net/manual/de/function.strtolower.php echo strtolower($myString);

ID: 240
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: myString = "my lovely Mr Singing Club" print myString.upper() // MY LOVELY MR SINGING CLUB print myString.lower()

ID: 241
PlCodelang: T-SQL
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: SELECT 'my lovely Mr Singing Club' AS myString ,UPPER('my lovely Mr Singing Club') AS myStringUpper ,LOWER('my lovely Mr Singing Club') AS myStringLower -- myString: my lovely Mr Singing Club -- myStringUpper: MY LOVELY MR SINGING CLUB -- myStringLower: my lovely mr singing club

ID: 242
PlCodelang: Bash Script
PlGroup: Fallunterscheidung
PlItemTitle: Wenn-Dann Abfrage
Code: VAR1=1 VAR2=2 if [ "$VAR1" -eq "$VAR2" ]; then echo "true"; else echo "false"; fi # false