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 11-20 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

279	T-SQL	Datum, Zeit	Gestriges Datum	SELECT GetDate() SELECT DATEADD(d, -1, GetDate()) SELECT GetDate()-1
282	PowerShell	Datum, Zeit	Gestriges Datum	$d=(Get-Date).AddDays(-1) $output=Get-Date $d -format "yyyy-MM-dd" # 2014-02-27
27	Delphi	Datum, Zeit	Aktuelles Datum/Uhrzeit	str:=FormatDateTime('yyyymmdd hhnnss',now); // gibt aus 20100331 120723
288	PL/pgSQL	Datum, Zeit	Gestriges Datum	SELECT (now())::date SELECT (now() + interval '-1 day')::date
290	T-SQL	Datum, Zeit	Aktuelles Datum/Uhrzeit	DECLARE @newDT DATETIME SET @newDT = CAST('2021-01-01 01:23:45' AS DATETIME) SELECT FORMAT(GETDATE(), 'yyyy-MM-dd', 'En') SELECT FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss', 'En')
293	BigQuery	Datum, Zeit	Gestriges Datum	SELECT CURRENT_TIMESTAMP() AS today_timestamp , DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY) AS yesterday_as_date
297	BigQuery	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT FORMAT_TIMESTAMP("%FT%H:%M:%E3S", CURRENT_DATETIME()) AS iso_date_string
298	EXASOL	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DDTHH24:MI:SS.FF3') AS iso_date_string
52	Java	Datum, Zeit	Aktuelles Datum/Uhrzeit	SimpleDateFormat formatter = new SimpleDateFormat ("yyyy.MM.dd 'at' HH:mm:ss "); Date currentTime = new Date(); System.out.println("Zeit und Datum : " + formatter.format(currentTime));
53	T-SQL	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	DECLARE @Now SMALLDATETIME ,@FirstDayOfMonth SMALLDATETIME ,@Laufperiode CHAR(21) ,@LastDayOfMonth SMALLDATETIME -- SET @Now = GetDate() SET @Now = {d '2008-02-01'} SET @FirstDayOfMonth = CAST(year(@Now) * 10000 + MONTH(@Now) * 100 + 1 as CHAR(8)) SET @Laufperiode = CONVERT(CHAR(10), @FirstDayOfMonth, 104) + '-' + CONVERT(CHAR(10), DATEADD(mm, 1, @FirstDayOfMonth) - 1, 104) SET @LastDayOfMonth=DATEADD(mm, 1, @FirstDayOfMonth)-1 SELECT [@Laufperiode] = @Laufperiode ,[@FirstDayOfMonth] = @FirstDayOfMonth ,[@LastDayOfMonth] = @LastDayOfMonth