Database Design

Current date minus report date

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2008

Posts: 2

Reputation: aamint is an unknown quantity at this point

Solved Threads: 0

aamint

Offline

Newbie Poster

Current date minus report date

Jul 25th, 2008

Hi, I'm developing issues database. How to get the ageing or how long the issues has been outstanding. TQ

•

Join Date: Apr 2008

Posts: 296

Reputation: tesuji is on a distinguished road

Solved Threads: 42

tesuji

Offline

Posting Whiz in Training

Re: Current date minus report date

Jul 25th, 2008

Hello

that depends on your specific database system. There are Database systems where you can
type in: select myBirthday - now() as "My age is:" ;

You need to know the current-date function of your database, for example: today(), now(), currentdate() etc.

krs,
tesu

•

Originally Posted by aamint

Hi, I'm developing issues database. How to get the ageing or how long the issues has been outstanding. TQ

Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.