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 261-270 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

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
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";