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

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')
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));
56	T-SQL	Datum, Zeit	Aktuelles Datum/Uhrzeit	SELECT GETDATE(); INSERT INTO table (datetime) VALUES (GETDATE());
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
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/
169	SQLite	Datum, Zeit	Aktuelles Datum/Uhrzeit	select date('now'); select time('now'); select datetime('now');
200	JavaScript	Datum, Zeit	Aktuelles Datum/Uhrzeit	date = new Date(); // Sat Jun 14 2014 13:15:27 GMT+0200 (CEST) dateStringISO = date.toISOString(); // "2014-06-14T11:15:27.097Z" // Attention: Time is different because of the timezone date.toISOString().substring(0,10); //"2014-06-14" dateStringISO.split("T")[1]; // 11:15:27.097Z