View PlGroup Datum, Zeit
| ID | 4 |
|---|
| Text | Datum, Zeit |
|---|
| Title | Not set |
|---|
PlItems
- SELECT NOW();
INSERT INTO table (datetime) VALUES (NOW());
- ; The first integer is the number of days since December 31, 1840, where day 1 is January 1, 1841. The second integer is the number of seconds since midnight of the current day
Set h=$horolog
S h=$H
W !,h ; gibt aus 61793,34937 was dem Datum 2010-03-08 und der Uhrzeit 09:42:17 entspricht
- ; Datum und Uhrzeit formatiert ausgeben
Set datuhr=$ZDateTime($Horolog,8)
; ergibt 20100308 09:47:36
; nur Datum
Set dat=$ZDate($Horolog,3) ; = 2010-03-08
; nur Zeit
Set uhr=$ZTime($Piece($H,",",2)) ; = 09:50:20
- $jetzt = time();
echo "jetzt: ".$jetzt;
echo "<br>";
echo "Human readable: ".date("H:i:s", $jetzt);
echo "<br>";
echo "zurück in Sekunden: ".strtotime(date("H:i:s", $jetzt));
echo "<br>";
- str:=FormatDateTime('yyyymmdd hhnnss',now);
// gibt aus 20100331 120723
- SimpleDateFormat formatter = new SimpleDateFormat ("yyyy.MM.dd 'at' HH:mm:ss ");
Date currentTime = new Date();
System.out.println("Zeit und Datum : " + formatter.format(currentTime));
- 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
- SELECT GETDATE();
INSERT INTO table (datetime) VALUES (GETDATE());
- -- http://www.postgresql.org/docs/9.1/static/functions-datetime.html
select extract(month from now())
- SELECT MONTH(GETDATE())
- select age({ts '1983-08-21 17:25:00'})
- select extract(year from now())
- 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";
- SELECT now();
- 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
- -- You get the local name for the spoken month name
SELECT to_char(now(), 'TMMonth')
-- results in german to "Januar" or "Dezember" (= "January", "December")
- select date_trunc('month', now()) -- first day in month
select date_trunc('month', now()) + interval '1 month - 1 day' -- last day in month
- #!/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/
- select date('now','start of month'); --first day of current month
select date('now','start of month', '+1 months','-1 day'); --last day of current month
- select date('now');
select time('now');
select datetime('now');
- from datetime import date, timedelta
d=date.today()-timedelta(days=1)
output=d.isoformat()
# 2014-02-27
- select date('now','-1 day');
- -- http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
SELECT (strftime('%s','now') - strftime('%s',date('now','-1 day'))) AS Seconds
-- https://stackoverflow.com/questions/289680/difference-between-2-dates-in-sqlite
SELECT CAST(JulianDay('now') - JulianDay(MAX(datetime_field_in_table)) * 24 * 60 AS Integer) AS diff_minutes FROM example_table
- --http://msdn.microsoft.com/de-de/library/ms189794.aspx
SELECT DATEDIFF(second, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000') AS Seconds
- 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
- 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
- -- 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;
- select DATEPART(ISO_WEEK,CAST('2014-08-25' AS DATE))
- SELECT strftime('%Y', '2014-08-25') AS Year;
- -- 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
- -- 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"
- SELECT extract(year from now()) AS Year;
SELECT extract(year from '2014-01-01') AS Year;
-- 2014
- SELECT extract(month from now()) AS Month;
SELECT extract(month from '2014-07-01') AS Month;
-- 7
- SELECT MAKETIME(19,53,20) AS TIME;
-- 19:53:20
SELECT MAKEDATE(2014,120) AS DATE;
-- ^^^
-- Day of Year
-- 2014-04-30
- 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
-
$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
- #!/bin/sh
myDate=$(date +"%Y-%m-%d" -d "yesterday")
echo $myDate
# 2014-01-13
myDate2=$(date -d @$(( $(date +"%s") - 86400)) +"%Y-%m-%d")
# 014-01-13
# today:
$(date +"%Y-%m-%d")
# 2014-01-14
# Hint: -d parameter doesn't work on Solaris
- SELECT GetDate()
SELECT DATEADD(d, -1, GetDate())
SELECT GetDate()-1
- $d=(Get-Date).AddDays(-1)
$output=Get-Date $d -format "yyyy-MM-dd"
# 2014-02-27
- SELECT (now())::date
SELECT (now() + interval '-1 day')::date
- 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')
- SELECT
CURRENT_TIMESTAMP() AS today_timestamp
, DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY) AS yesterday_as_date
- SELECT FORMAT_TIMESTAMP("%FT%H:%M:%E3S", CURRENT_DATETIME()) AS iso_date_string
- SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DDTHH24:MI:SS.FF3') AS iso_date_string