Current date minus report date

Expand Post »

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

aamint

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2008

Permalink

Jul 25th, 2008

Re: Current date minus report date

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

Click to Expand / Collapse Quote originally posted by aamint ...

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

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

Jul 28th, 2008

Re: Current date minus report date

Ok. I got it already. Thank you.

aamint

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: Relational Database Modelling Question

Next Thread in Database Design Forum Timeline: database design for question system

DaniWeb Message

Cancel Changes

User Name
Password