PlItems

ID: 163
PlCodelang: Bash Script
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: #!/bin/sh myDate=$(date +"%Y-%m-%d") echo $myDate # 2014-01-14 echo $(date +"%Y-%m-%d_%a") # with short dayname # 2017-01-05_Do (Do => German, localized short of Tuesday) echo $(date +"%Y-%m-%d %H:%M:%S") # 2014-01-14 22:15 # List of formatting options: https://www.cyberciti.biz/faq/linux-unix-formatting-dates-for-display/

ID: 164
PlCodelang: Python
PlGroup: Variablen
PlItemTitle: Auflistung aller Variablen
Code: import pprint a="This is a test" b=1 c=True pprint.pprint(locals()) #{'__builtins__': <module '__builtin__' (built-in)>, # '__doc__': None, # '__name__': '__main__', # '__package__': None, # 'a': 'This is a test', # 'b': 1, # 'c': True, # 'pprint': <module 'pprint' from '/usr/lib/python2.7/pprint.pyc'>} pprint.pprint(globals())

ID: 165
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Auflistung aller Variablen
Code: S A="This is a test" Set b=1 ZW ZWrite

ID: 166
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Datei auf dem Betriebssystem ausführen
Code: import commands output=commands.getoutput("dir") print output # home tmp myFile.sh

ID: 167
PlCodelang: Bash Script
PlGroup: Prozeduren, Funktionen, Methoden
PlItemTitle: Deklaration einer Funktion/Prozedur
Code: #!/bin/sh do_something() { echo $1 echo $2 } do_something "this is my first" " and second argument" # this is my first and second argument

ID: 168
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Erster und letzter Tag des Monats ermitteln
Code: select date('now','start of month'); --first day of current month select date('now','start of month', '+1 months','-1 day'); --last day of current month

ID: 169
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: select date('now'); select time('now'); select datetime('now');
Result Example:

2008-01-16 14:16:01 2008-01-16 14:16:01

ID: 170
PlCodelang: Python
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: from datetime import date, timedelta d=date.today()-timedelta(days=1) output=d.isoformat() # 2014-02-27

ID: 171
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: select date('now','-1 day');

ID: 172
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Zeitdifferenz
Link Technical Documentation: https://www.sqlite.org/lang_datefunc.html
Code: -- http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions SELECT (strftime('%s','now') - strftime('%s',date('now','-1 day'))) AS Seconds -- https://stackoverflow.com/questions/289680/difference-between-2-dates-in-sqlite SELECT CAST(JulianDay('now') - JulianDay(MAX(datetime_field_in_table)) * 24 * 60 AS Integer) AS diff_minutes FROM example_table

ID: 173
PlCodelang: T-SQL
PlGroup: Datum, Zeit
PlItemTitle: Zeitdifferenz
Code: --http://msdn.microsoft.com/de-de/library/ms189794.aspx SELECT DATEDIFF(second, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000') AS Seconds

ID: 174
PlCodelang: Bash Script
PlGroup: Strings
PlItemTitle: Strings miteinander verbinden
Code: # http://wiki.ubuntuusers.de/Shell/Bash-Skripting-Guide_f%C3%BCr_Anf%C3%A4nger#Variablen-abgrenzen #!/bin/bash subString1="Hello" subString2='World!' echo "${subString1} ${subString2}" Hello World! echo "${subString1} ${subString2}. I'm in here ;-)" # Hello World!. I'm in here ;-)

ID: 175
PlCodelang: Bash Script
PlGroup: Filehandling
PlItemTitle: Verzeichnis rekursiv durchsuchen
Code: # http://wiki.ubuntuusers.de/Shell/Bash-Skripting-Guide_f%C3%BCr_Anf%C3%A4nger#Variablen-Teil-2 #!/bin/bash for file in /home/myUser/*/*.png ; do echo "Diese Datei: $file" fname=$(basename "$file") echo "hat den Namen: $fname" fdir=$(dirname "$file") echo "und steht im Verzeichnis: $fdir" # Diese Datei: /home/myUser/galaxy.png # hat den Namen: galaxy.png # und steht im Verzeichnis: /home/myUser

ID: 176
PlCodelang: Bash Script
PlGroup: Filehandling
PlItemTitle: Prüfen ob Datei existiert
Code: # http://wiki.ubuntuusers.de/Shell/Bash-Skripting-Guide_f%C3%BCr_Anf%C3%A4nger#If-Else-Anweisung #!/bin/bash filePath="/home/myUser/test.txt" if [ -f ${filePath} ] then echo "There it is! ;-)" else echo "Whow, file is missing at this place :-(" fi

ID: 177
PlCodelang: Delphi
PlGroup: Filehandling
PlItemTitle: Prüfen ob Datei existiert
Code: procedure TForm1.CheckIfFileExists(); var filePath : String; begin filePath:='C:\User\myUser\text.txt'; if FileExists(filePath) then begin ShowMessage('There it is! ;-)'); end else begin ShowMessage('Whow, file is missing at this place :-('); end; end;

ID: 178
PlCodelang: C#
PlGroup: Filehandling
PlItemTitle: Prüfen ob Datei existiert
Code: String filePath = "C:\\User\\myUser\\text.txt"; if (System.IO.File.Exists(filePath)) { MessageBox.Show("There it is! ;-)"); } else { MessageBox.Show("Whow, file is missing at this place :-("); }

ID: 179
PlCodelang: PHP
PlGroup: Filehandling
PlItemTitle: Prüfen ob Datei existiert
Code: $filePath = "/home/myUser/test.txt"; if (file_exists($filePath)) { echo "There it is! ;-)" } else { "Whow, file is missing at this place :-(" }

ID: 180
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: NULL Wert eines Feldes übersteuern
Code: SELECT ISNULL(MyColumn1, 1.0) AS MyColumnWithoutNULL;

ID: 181
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: NULL Wert eines Feldes übersteuern
Code: SELECT COALESCE(MyColumn1, 1.0) AS MyColumnWithoutNULL;

ID: 182
PlCodelang: Batch
PlGroup: Variablen
PlItemTitle: Deklaration einer Variable
Code: @echo off SET myVariable=This is my content SET myPathVariableWithBlanks="C:\Temp\Path With Blanks\File.txt" echo %myVariable% REM This is my content echo %myPathVariableWithBlanks% REM "C:\Temp\Path With Blanks\File.txt"