Welcome to Programmers Language v2

ID: 203
PlCodelang: Java
PlGroup: Filehandling
PlItemTitle: Ternary operator
Code: String thisVar = "OK"; boolean resultVar; resultVar = thisVar.equals("OK") ? true : false; // same as if-else construction if (thisVar.equals("OK")) { resultVar = true; } else { resultVar = false; }

ID: 204
PlCodelang: Python
PlGroup: Fallunterscheidung
PlItemTitle: Ternary operator
Code: thisVar = "OK" resultVar = False # [on_true] if [cond] else [on_false] resultVar = True if thisVar == "OK" else False // same as if-else construction if (thisVar == "OK"): resultVar = True else: resultVar = False

ID: 205
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: 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

ID: 206
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabelle DB übergreifend kopieren
Code: DROP TABLE IF EXISTS `DestinationDB`.`Table1`; CREATE TABLE `DestinationDB`.`Table1` SELECT * FROM `SourceDB`.`Table1`;

ID: 207
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Manuell einen AutoIncrement/Identity/Serial Wert in Tabelle einfügen
Code: SET IDENTITY_INSERT myTable ON INSERT INTO myTable(Identity_ID, Value) VALUES (4711, 'Back To The Future...') SET IDENTITY_INSERT myTable OFF

ID: 208
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Tabelleinhalt DB übergreifend kopieren
Code: -- siehe auch: http://stackoverflow.com/questions/6083132/postgresql-insert-into-select -- in DestinationDB do: INSERT INTO Table1 SELECT id, valuefield FROM dblink('dbname=SourceDB', 'SELECT id, valuefield FROM Table1') AS t(id integer, valuefield varchar(100));

ID: 209
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Kalenderwoche eines Datums
Code: -- Standard Weeknumber function from SQLite: -- http://www.sqlite.org/lang_datefunc.html SELECT strftime('%W', '2014-08-25') -- The above calculation can lead to an wrong number if you expect an iso calendar week. -- Therefore better: -- http://stackoverflow.com/questions/15082584/sqlite-return-wrong-week-number-for-2013 SELECT (strftime('%j', date('2014-08-25', '-3 days', 'weekday 4')) - 1) / 7 + 1 AS ISOCalendarWeekNumber;

ID: 210
PlCodelang: T-SQL
PlGroup: Datum, Zeit
PlItemTitle: Kalenderwoche eines Datums
Code: select DATEPART(ISO_WEEK,CAST('2014-08-25' AS DATE))

ID: 211
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: SELECT strftime('%Y', '2014-08-25') AS Year;

ID: 212
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: -- There is no build in solution. Because of this you have to build a solution out of the weekday. -- Be careful, the first weekday (0) is a sunday SELECT ,CASE CAST(strftime('%w', myDateField) as integer) WHEN 0 then 'Sonntag' WHEN 1 then 'Montag' WHEN 2 then 'Dienstag' WHEN 3 then 'Mittwoch' WHEN 4 then 'Donnerstag' WHEN 5 then 'Freitag' WHEN 6 then 'Samstag' ELSE '????????????????????' END AS Tag_der_Woche_Deutsch ,CASE CAST(strftime('%w', myDateField) as integer) WHEN 0 then 'Sunday' WHEN 1 then 'Monday' WHEN 2 then 'Tuesday' WHEN 3 then 'Wednesday' WHEN 4 then 'Thursday' WHEN 5 then 'Friday' WHEN 6 then 'Saturday' ELSE '????????????????????' END AS Day_of_week_English