Welcome to Programmers Language v2

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');

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
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