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>
|
- Re: Select statement: Data Time Stamp Manipulation,
Seay, Paul <=
|
|
|