ADSM-L

Re: Select statement: Data Time Stamp Manipulation

2002-02-19 15:24:29
Subject: Re: Select statement: Data Time Stamp Manipulation
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Tue, 19 Feb 2002 15:20:21 -0500
The character representation of the CURRENT_TIMESTAMP is called a TIMESTAMP,
same for any date/time field in TIMESTAMP format.  There are many functions
you can use against it to get portions of the field.  The functions are:

        DATE()
        HOUR()
        MINUTE()
        SECOND()

to name a few.  Look in the DB2 SQL Command Reference if you have it.

You can do something like this:

        CURRENT_TIMESTAMP - 14 DAYS
        CURRENT_TIMESTAMP - 2 HOURS

As arguments in a WHERE clause.

<Prev in Thread] Current Thread [Next in Thread>