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.
select DATEPART(ISO_WEEK,CAST('2014-08-25' AS DATE))
211
SQLite
Datum, Zeit
Jahr aus Datum extrahieren
SELECT strftime('%Y', '2014-08-25') AS Year;
212
SQLite
Datum, Zeit
Tagesname
-- 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
216
ORACLE PL/SQL
Datum, Zeit
Aktuelles Datum/Uhrzeit
-- if todays date is: 2014-02-02 then a static query would be
SELECT TO_DATE('02/02/2014','dd/mm/yyyy') FROM dual
-- system variable
SELECT SYSDATE AS TODAY FROM SYS."DUAL"
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
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
232
MySQL
Datum, Zeit
Datum/Uhrzeit zusammensetzen
SELECT MAKETIME(19,53,20) AS TIME;
-- 19:53:20
SELECT MAKEDATE(2014,120) AS DATE;
-- ^^^
-- Day of Year
-- 2014-04-30
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
234
PowerShell
Datum, Zeit
Aktuelles Datum/Uhrzeit
$myDate=Get-Date -format "yyyy-MM-dd hh:mm";
write-host $myDate -Foregroundcolor Cyan;
# 2014-01-14 10:15 # Maybe AM or PM
# For 24h Version
$myDate=Get-Date -format "yyyy-MM-dd HH:mm";
write-host $myDate -Foregroundcolor Cyan;
# 2014-01-14 22:15
