Unix C++
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Difference ?

2 posters

Unix C++ :: UNIX CPP :: RDBMS & ORACLE

Go down

Difference ? Empty Difference ?

Post by Maithreyi Mon Mar 22, 2010 7:03 pm

For each employee, calculate the number of months between today and the date the employee was hired. Order your result by the number of months an employee has been employed. Round the number of months to the closest whole number.


is der any function to calculate today's date ?

Maithreyi

Posts : 76
Points : 142
Join date : 2010-03-03
Age : 36
Location : Haldia

Back to top Go down

Difference ? Empty Re: Difference ?

Post by Vineet_More Mon Mar 22, 2010 7:09 pm

Sysdate keyword will give you the current system date.

Vineet_More

Posts : 27
Points : 31
Join date : 2010-02-26

Back to top Go down

Difference ? Empty Re: Difference ?

Post by Maithreyi Mon Mar 22, 2010 7:21 pm

Thanks! Sorry about the repeated post!

Maithreyi

Posts : 76
Points : 142
Join date : 2010-03-03
Age : 36
Location : Haldia

Back to top Go down

Difference ? Empty Re: Difference ?

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

Unix C++ :: UNIX CPP :: RDBMS & ORACLE

 
Permissions in this forum:
You cannot reply to topics in this forum