Your Web News in One Place

An Interest In:

Web News this Week

Search Archive

Some of Our Sources

View All Sources

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
April 14, 2022 11:22 am GMT

What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.

On 31/1, when you read this message like this, can you immediately think of what day it is?

"It will expire one month after the registration date."

Also, what about the following message on 31/3?

"One month's notice will be given."

I looked into this, but I couldn't find any legal provisions or international rules.

So, I decided to research it with various RDBs.

I tried with:

  • MySQL
  • PostgreSQL
  • SQL Server
  • Oracle

In all RDBs result were the same.

Result

ContentsResult
1 month after 28/128/2
1 month after 29/128/2
1 month after 30/128/2
1 month after 31/128/2
1 month before 28/328/2
1 month before 29/328/2
1 month before 30/328/2
1 month before 31/328/2
1 month after 28/1(leap year)28/2
1 month after 29/1(leap year)29/2
1 month after 30/1(leap year)29/2
1 month after 31/1(leap year)29/2
1 month before 28/3(leap year)28/2
1 month before 29/3(leap year)29/2
1 month before 30/3(leap year)29/2
1 month before 31/3(leap year)29/2

SQLstatement

MySQL

ver5.7

SELECT    DATE_ADD(CAST('2018/01/28' AS DATE), INTERVAL 1 MONTH) AS "1 month after 28/1"   ,DATE_ADD(CAST('2018/01/29' AS DATE), INTERVAL 1 MONTH) AS "1 month after 29/1"   ,DATE_ADD(CAST('2018/01/30' AS DATE), INTERVAL 1 MONTH) AS "1 month after 30/1"   ,DATE_ADD(CAST('2018/01/31' AS DATE), INTERVAL 1 MONTH) AS "1 month after 31/1"   ,DATE_ADD(CAST('2018/03/28' AS DATE), INTERVAL -1 MONTH) AS "1 month before 28/3"   ,DATE_ADD(CAST('2018/03/29' AS DATE), INTERVAL -1 MONTH) AS "1 month before 29/3"   ,DATE_ADD(CAST('2018/03/30' AS DATE), INTERVAL -1 MONTH) AS "1 month before 30/3"   ,DATE_ADD(CAST('2018/03/31' AS DATE), INTERVAL -1 MONTH) AS "1 month before 31/3"   ,DATE_ADD(CAST('2020/01/28' AS DATE), INTERVAL 1 MONTH) AS "1 month after 28/1(leap year)"   ,DATE_ADD(CAST('2020/01/29' AS DATE), INTERVAL 1 MONTH) AS "1 month after 29/1(leap year)"   ,DATE_ADD(CAST('2020/01/30' AS DATE), INTERVAL 1 MONTH) AS "1 month after 30/1(leap year)"   ,DATE_ADD(CAST('2020/01/31' AS DATE), INTERVAL 1 MONTH) AS "1 month after 31/1(leap year)"   ,DATE_ADD(CAST('2020/03/28' AS DATE), INTERVAL -1 MONTH) AS "1 month before 28/3(leap year)"   ,DATE_ADD(CAST('2020/03/29' AS DATE), INTERVAL -1 MONTH) AS "1 month before 29/3(leap year)"   ,DATE_ADD(CAST('2020/03/30' AS DATE), INTERVAL -1 MONTH) AS "1 month before 30/3(leap year)"   ,DATE_ADD(CAST('2020/03/31' AS DATE), INTERVAL -1 MONTH) AS "1 month before 31/3(leap year)"

PostgreSQL

ver9.6

SELECT    CAST('2018/01/28' AS DATE) + interval '1 months' AS "1 month after 28/1"   ,CAST('2018/01/29' AS DATE) + interval '1 months' AS "1 month after 29/1"   ,CAST('2018/01/30' AS DATE) + interval '1 months' AS "1 month after 30/1"   ,CAST('2018/01/31' AS DATE) + interval '1 months' AS "1 month after 31/1"   ,CAST('2018/03/28' AS DATE) + interval '-1 months' AS "1 month before 28/3"   ,CAST('2018/03/29' AS DATE) + interval '-1 months' AS "1 month before 29/3"   ,CAST('2018/03/30' AS DATE) + interval '-1 months' AS "1 month before 30/3"   ,CAST('2018/03/31' AS DATE) + interval '-1 months' AS "1 month before 31/3"   ,CAST('2020/01/28' AS DATE) + interval '1 months' AS "1 month after 28/1(leap year)"   ,CAST('2020/01/29' AS DATE) + interval '1 months' AS "1 month after 29/1(leap year)"   ,CAST('2020/01/30' AS DATE) + interval '1 months' AS "1 month after 30/1(leap year)"   ,CAST('2020/01/31' AS DATE) + interval '1 months' AS "1 month after 31/1(leap year)"   ,CAST('2020/03/28' AS DATE) + interval '-1 months' AS "1 month before 28/3(leap year)"   ,CAST('2020/03/29' AS DATE) + interval '-1 months' AS "1 month before 29/3(leap year)"   ,CAST('2020/03/30' AS DATE) + interval '-1 months' AS "1 month before 30/3(leap year)"   ,CAST('2020/03/31' AS DATE) + interval '-1 months' AS "1 month before 31/3(leap year)"

SQL Server

ver14.0

SELECT    DATEADD(MONTH, 1, CAST('2018/01/28' AS DATE)) AS "1 month after 28/1"   ,DATEADD(MONTH, 1, CAST('2018/01/29' AS DATE)) AS "1 month after 29/1"   ,DATEADD(MONTH, 1, CAST('2018/01/30' AS DATE)) AS "1 month after 30/1"   ,DATEADD(MONTH, 1, CAST('2018/01/31' AS DATE)) AS "1 month after 31/1"   ,DATEADD(MONTH, -1, CAST('2018/03/28' AS DATE)) AS "1 month before 28/3"   ,DATEADD(MONTH, -1, CAST('2018/03/29' AS DATE)) AS "1 month before 29/3"   ,DATEADD(MONTH, -1, CAST('2018/03/30' AS DATE)) AS "1 month before 30/3"   ,DATEADD(MONTH, -1, CAST('2018/03/31' AS DATE)) AS "1 month before 31/3"   ,DATEADD(MONTH, 1, CAST('2020/01/28' AS DATE)) AS "1 month after 28/1(leap year)"   ,DATEADD(MONTH, 1, CAST('2020/01/29' AS DATE)) AS "1 month after 29/1(leap year)"   ,DATEADD(MONTH, 1, CAST('2020/01/30' AS DATE)) AS "1 month after 30/1(leap year)"   ,DATEADD(MONTH, 1, CAST('2020/01/31' AS DATE)) AS "1 month after 31/1(leap year)"   ,DATEADD(MONTH, -1, CAST('2020/03/28' AS DATE)) AS "1 month before 28/3(leap year)"   ,DATEADD(MONTH, -1, CAST('2020/03/29' AS DATE)) AS "1 month before 29/3(leap year)"   ,DATEADD(MONTH, -1, CAST('2020/03/30' AS DATE)) AS "1 month before 30/3(leap year)"   ,DATEADD(MONTH, -1, CAST('2020/03/31' AS DATE)) AS "1 month before 31/3(leap year)"

Oracle

ver11g

SELECT    ADD_MONTHS(TO_DATE('2018/01/28'), 1) AS "1 month after 28/1"   ,ADD_MONTHS(TO_DATE('2018/01/29'), 1) AS "1 month after 29/1"   ,ADD_MONTHS(TO_DATE('2018/01/30'), 1) AS "1 month after 30/1"   ,ADD_MONTHS(TO_DATE('2018/01/31'), 1) AS "1 month after 31/1"   ,ADD_MONTHS(TO_DATE('2018/03/31'), -1) AS "1 month before 28/3"   ,ADD_MONTHS(TO_DATE('2018/03/31'), -1) AS "1 month before 29/3"   ,ADD_MONTHS(TO_DATE('2018/03/31'), -1) AS "1 month before 30/3"   ,ADD_MONTHS(TO_DATE('2018/03/31'), -1) AS "1 month before 31/3"   ,ADD_MONTHS(TO_DATE('2020/01/28'), 1) AS "1 month after 28/1(leap year)"   ,ADD_MONTHS(TO_DATE('2020/01/29'), 1) AS "1 month after 29/1(leap year)"   ,ADD_MONTHS(TO_DATE('2020/01/30'), 1) AS "1 month after 30/1(leap year)"   ,ADD_MONTHS(TO_DATE('2020/01/31'), 1) AS "1 month after 31/1(leap year)"   ,ADD_MONTHS(TO_DATE('2020/03/31'), -1) AS "1 month before 28/3(leap year)"   ,ADD_MONTHS(TO_DATE('2020/03/31'), -1) AS "1 month before 29/3(leap year)"   ,ADD_MONTHS(TO_DATE('2020/03/31'), -1) AS "1 month before 30/3(leap year)"   ,ADD_MONTHS(TO_DATE('2020/03/31'), -1) AS "1 month before 31/3(leap year)"FROM    DUAL

Extra

If you want to notify the expiration date, it may be better to use days instead of month, such as "The data retention period is 90 days".


Original Link: https://dev.to/kakisoft/what-day-is-one-month-after-31st-january-what-day-is-one-month-before-31st-march-i-checked-it-with-various-rdbs-4j5k

Share this article:    Share on Facebook
View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To