| Author |
date calculation inside select clause
|
rick collette
Ranch Hand
Joined: Mar 22, 2002
Posts: 208
|
|
Hi,
I have two columns of type TIMESTAMP defined inside a table:
start_date and stop_date. Is there any way I can calculate
how many days between start_date and stop_date inside my SELECT
clause so that I do not have do it after I get these two values
from my database?
regards,
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26144
|
|
Rick,
In db2, there is a days() function. So you could easily subtract in your select clause. I don't remember if this is db2 specific though.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
arnel nicolas
Ranch Hand
Joined: Dec 16, 2003
Posts: 149
|
|
|
Also in MSSQL you can use DATEDIFF function.
|
|
Sonny Gill
Ranch Hand
Joined: Feb 02, 2002
Posts: 1211
|
|
|
In Oracle, AFAIK, you can just subtract one date from the other to get the number of days
|
The future is here. It's just not evenly distributed yet. - William Gibson
Consultant @ Xebia. Sonny Gill Tweets
|
|
rick collette
Ranch Hand
Joined: Mar 22, 2002
Posts: 208
|
|
|
Thanks a lot guys. I am using db2. I will try out you guys' suggestions.
|
|
 |
|
|
subject: date calculation inside select clause
|
|
|
0
