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 231-240 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

210	T-SQL	Datum, Zeit	Kalenderwoche eines Datums	select DATEPART(ISO_WEEK,CAST('2014-08-25' AS DATE))
233	MySQL	Datum, Zeit	Datum/Uhrzeit berechnen	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
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
205	MySQL	Datum, Zeit	Tagesname	SELECT DAYNAME(NOW()); -- Monday SELECT DAYNAME('2014-08-10'); -- Sunday -- To get localized names switch the parameter, e.g. to German SET lc_time_names = 'de_DE'; SELECT DAYNAME('2014-08-10'); -- Sonntag
140	T-SQL	Datenbank	Aktuellen Datenbanknamen ausgeben	SELECT DB_NAME() AS DB_Name
231	MySQL	Datum, Zeit	Monat aus Datum extrahieren	SELECT extract(month from now()) AS Month; SELECT extract(month from '2014-07-01') AS Month; -- 7
147	PL/pgSQL	Datum, Zeit	Jahr aus Datum extrahieren	select extract(year from now())
230	MySQL	Datum, Zeit	Jahr aus Datum extrahieren	SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014
247	ORACLE PL/SQL	Datenbank	CSV erstellen	SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;
137	T-SQL	Datenmengen	Differenzen anzeigen	SELECT field_to_compare FROM Destination_Table EXCEPT SELECT field_to_compare FROM Source_Table