середа, 16 вересня 2009 р.

How to add 1 day to the date

MySQL : dateadd(dd, 1, getdate())
Oracle : SYSTIMESTAMP+NUMTODSINTERVAL(1,'day')
DB2 : CURRENT TIMESTAMP+1 DAY
PostgreSQL : LOCALTIMESTAMP+INTERVAL '1 day'

1 коментар:

  1. This post gives you query to add 1 day to the date in different database. I already knew how to add day in MySQL but Oracle and DB2 are new for me. Your post is useful as we get to know new short cuts. Thanks.
    oracle ebs

    ВідповістиВидалити