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 21-30 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

56	T-SQL	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT GETDATE(); INSERT INTO table (datetime) VALUES (GETDATE());
121	PL/pgSQL	Datum, Zeit	Monat aus Datum extrahieren	-- http://www.postgresql.org/docs/9.1/static/functions-datetime.html select extract(month from now())
122	T-SQL	Datum, Zeit	Monat aus Datum extrahieren	SELECT MONTH(GETDATE())
123	PL/pgSQL	Datum, Zeit	Alter zu gegebenen Datum ermitteln	select age({ts '1983-08-21 17:25:00'})
147	PL/pgSQL	Datum, Zeit	Jahr aus Datum extrahieren	select extract(year from now())
149	Perl	Datum, Zeit	Jahr aus Datum extrahieren	use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/; # Datum Vorbereitung: my $DateTime = POSIX::strftime('%c', localtime(time)); my ($Date, $Time) = split(/\s+/, $DateTime); my ($Day, $Month, $Year) = split(/\./, $Date); my ($Hour, $Minute, $Second) = split(/:/, $Time ); my $Datum = "$Year"."$Month"."$Day"; #oder # my $Datum = "$Day"."$Month"."$Year"; my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";
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