Datum & Tijd (MySQL): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
(6 tussenliggende versies door dezelfde gebruiker niet weergegeven) | |||
Regel 1: | Regel 1: | ||
− | == | + | == Time stamp & date stamp == |
− | |||
− | |||
<pre> | <pre> | ||
Regel 9: | Regel 7: | ||
</pre> | </pre> | ||
− | + | <pre> | |
+ | select date_format(now(),"%Y%m%d_%H%i%s"); | ||
+ | 20200115_143829 | ||
+ | </pre> | ||
+ | |||
+ | <pre> | ||
+ | select date_format(now(),"%Y.%m.%d"); | ||
+ | 2020.01.15 | ||
+ | </pre> | ||
<pre> | <pre> | ||
Regel 23: | Regel 29: | ||
select now()+interval 50 day; -- 2017-06-17 17:18:53 | select now()+interval 50 day; -- 2017-06-17 17:18:53 | ||
select date_format(now()+interval 90 day,"%m/%d/%Y"); -- 07/27/2017 | select date_format(now()+interval 90 day,"%m/%d/%Y"); -- 07/27/2017 | ||
− | |||
− | |||
</pre> | </pre> | ||
Regel 38: | Regel 42: | ||
<pre> | <pre> | ||
− | select unix_timestamp(now()); # Output: | + | select unix_timestamp(now()); # Output: 1676745678 |
select unix_timestamp("Oct. 19, 2015"); # Output: 0 | select unix_timestamp("Oct. 19, 2015"); # Output: 0 | ||
select unix_timestamp("2015-10-19"); # Output: 1445205600 | select unix_timestamp("2015-10-19"); # Output: 1445205600 | ||
Regel 45: | Regel 49: | ||
select unix_timestamp("2011-07"); # Output: 0 | select unix_timestamp("2011-07"); # Output: 0 | ||
</pre> | </pre> | ||
+ | |||
+ | == See also == | ||
+ | |||
+ | * [[Unix Epoch Time]] | ||
== Bronnen == | == Bronnen == |
Huidige versie van 18 feb 2023 om 20:41
Time stamp & date stamp
select date_format(now(),"%Y%m%d_%H%i"); 20180724_1124
select date_format(now(),"%Y%m%d_%H%i%s"); 20200115_143829
select date_format(now(),"%Y.%m.%d"); 2020.01.15
select now(); -- 2017-04-28 17:17:02 select date_format(now(),"%m"); -- 04 select date_format(now(),'%m'); -- 04 select date_format(now(),"%d"); -- 28 select date_format(now(),"%m/%d/%y"); -- 04/28/17 select date_format(now(),"%m/%d/%Y"); -- 04/28/2017 select date_format(now(),"%m-%d-%Y"); -- 04-28/2017 select date_format(now(),"%m/%d/%Y")+50; -- 54 → Dit werkt dus niet select date_format(now()+50,"%m/%d/%Y"); -- Null select now()+interval 50 day; -- 2017-06-17 17:18:53 select date_format(now()+interval 90 day,"%m/%d/%Y"); -- 07/27/2017
Unix Time - from_unixtime()
Met from_unixtime()
kun je Unix tijdwaardes leesbaar formatteren. Bv.:
select from_unixtime(1453991397); # Output: 2016-01-28 15:29:57
Unix Time - unix_timestamp()
Met unix_timestamp()
converteer je een datum of tijd in een leesbaar formaat terug naar Unix Time:
select unix_timestamp(now()); # Output: 1676745678 select unix_timestamp("Oct. 19, 2015"); # Output: 0 select unix_timestamp("2015-10-19"); # Output: 1445205600 select unix_timestamp("2011-07-11 07:50:51"); # Output: 1310363451 select unix_timestamp("2011-07-11"); # Output: 1310335200 select unix_timestamp("2011-07"); # Output: 0