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 271-280 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

153	PL/pgSQL	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT now();
155	Python	Datum, Zeit	Aktuelles Datum/Uhrzeit	from datetime import date iso_datum = date.today().isoformat() output = iso_datum print output # 2013-12-05 # or import datetime datetime.datetime.now().strftime("%Y-%m-%d_%H-%M-%S") # 2013-12-05_18-09-10
156	PL/pgSQL	Datum, Zeit	Monat aus Datum extrahieren	-- You get the local name for the spoken month name SELECT to_char(now(), 'TMMonth') -- results in german to "Januar" or "Dezember" (= "January", "December")
157	PL/pgSQL	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	select date_trunc('month', now()) -- first day in month select date_trunc('month', now()) + interval '1 month - 1 day' -- last day in month
163	Bash Script	Datum, Zeit	Aktuelles Datum/Uhrzeit	#!/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/
168	SQLite	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	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
169	SQLite	Datum, Zeit	Aktuelles Datum/Uhrzeit	select date('now'); select time('now'); select datetime('now');
170	Python	Datum, Zeit	Gestriges Datum	from datetime import date, timedelta d=date.today()-timedelta(days=1) output=d.isoformat() # 2014-02-27
171	SQLite	Datum, Zeit	Gestriges Datum	select date('now','-1 day');
172	SQLite	Datum, Zeit	Zeitdifferenz	-- 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