## Basic syntax ```SQL DATEADD(<Unit of time>, <Units>, <Date>) -- Add 5 days to 04/23/2021 DATEADD(DAY, 5, '2021-04-23') -- Substract 5 days to 04/23/2021 DATEADD(MONTH, -5, '2021-04-23') ``` ## Units of time | Unit of time | Abbreviation | | ------------ | ------------ | | NANOSECOND | ns | | MICROSECOND | mcs | | MILLISECOND | ms | | SECOND | ss, s | | MINUTE | mi, n | | HOUR | hh | | WEEKDAY | dw, w | | WEEK | wk, ww | | DAY | dd, d | | DAYOFYEAR | dy, d | | MONTH | mm, m | | QUARTER | qq, q | | YEAR | yy, yyyy | ## More information To get more info on the [Docs](https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15)
author | lauweded |
---|---|
permlink | dateadd-to-change-datetimes-in |
category | hive-169321 |
json_metadata | "{"links": ["https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15"], "tags": ["hive-169321", "sql", "sql-server", "datetime", "dev", "dev-girl", "programming", "db"], "app": "ecency/3.0.16-vision", "format": "markdown+html"}" |
created | 2021-04-25 13:58:27 |
last_update | 2021-04-25 13:58:27 |
depth | 0 |
children | 1 |
last_payout | 2021-05-02 13:58:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.491 HBD |
curator_payout_value | 0.486 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 957 |
author_reputation | 1,047,785,333,462 |
root_title | "DATEADD to change datetimes in SQL Server" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 103,283,367 |
net_rshares | 1,426,849,462,424 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
ausbitbank | 0 | 140,494,950,959 | 10% | ||
rishi556 | 0 | 11,400,420,393 | 100% | ||
sn0n | 0 | 53,605,366,059 | 16% | ||
alphacore | 0 | 25,312,298,333 | 4.04% | ||
rafaelaquino | 0 | 15,757,637,772 | 100% | ||
blokz | 0 | 646,135,477 | 16% | ||
deathwing | 0 | 105,759,159,050 | 20% | ||
edicted | 0 | 679,753,897,625 | 10% | ||
cadawg | 0 | 70,135,871,248 | 18% | ||
foxon | 0 | 197,111,159,435 | 20% | ||
abbenay | 0 | 478,149,541 | 5% | ||
giftgiver | 0 | 12,281,671,069 | 20% | ||
gloriaolar | 0 | 4,447,663,249 | 3% | ||
hextech | 0 | 9,357,294,181 | 20% | ||
mafia.wallet | 0 | 767,784,361 | 20% | ||
nftmart | 0 | 4,960,974,009 | 20% | ||
mrtats | 0 | 5,559,342,175 | 40% | ||
betterdev | 0 | 45,168,777,391 | 20% | ||
hykss.leo | 0 | 38,230,337,991 | 20% | ||
bananass | 0 | 4,821,860,909 | 5% | ||
thecouncil | 0 | 798,711,197 | 20% |
Congratulations @lauweded! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : <table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@lauweded/payout.png?202105051552"></td><td>You received more than 50 HP as payout for your posts and comments.<br>Your next payout target is 100 HP.<br><sub>The unit is Hive Power equivalent because your rewards can be split into HP and HBD</sub></td></tr> </table> <sub>_You can view your badges on [your board](https://hivebuzz.me/@lauweded) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> **Check out the last post from @hivebuzz:** <table><tr><td><a href="/hivebuzz/@hivebuzz/false-positive"><img src="https://images.hive.blog/64x128/https://i.imgur.com/0jzfGcE.png"></a></td><td><a href="/hivebuzz/@hivebuzz/false-positive">False-Positive phishing alert reported by antivirus software</a></td></tr><tr><td><a href="/hivebuzz/@hivebuzz/pud-202105-feedback"><img src="https://images.hive.blog/64x128/https://i.imgur.com/zHjYI1k.jpg"></a></td><td><a href="/hivebuzz/@hivebuzz/pud-202105-feedback">Feedback from the May 1st Hive Power Up Day</a></td></tr></table> ###### Support the HiveBuzz project. [Vote](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22109%22%5D&approve=true) for [our proposal](https://peakd.com/me/proposals/147)!
author | hivebuzz |
---|---|
permlink | hivebuzz-notify-lauweded-20210506t002644000z |
category | hive-169321 |
json_metadata | {"image":["http://hivebuzz.me/notify.t6.png"]} |
created | 2021-05-06 00:26:42 |
last_update | 2021-05-06 00:26:42 |
depth | 1 |
children | 0 |
last_payout | 2021-05-13 00:26:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,517 |
author_reputation | 369,385,216,814,911 |
root_title | "DATEADD to change datetimes in SQL Server" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 103,515,482 |
net_rshares | 0 |