On 20 October 2010 11:46, Anish A <[email protected]> wrote: > Hai, > > I am doing my database lab in postgresql. I need some help regarding > some functions. > > How can I calculate the employee who has service more than 2 years? > > The date of joining is stored in employee table.
Refer the following: http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html http://wiki.postgresql.org/wiki/Working_with_Dates_and_Times_in_PostgreSQL http://archives.postgresql.org/pgsql-sql/2001-06/msg00556.php Hope this helps. -- Manilal K M : മണിലാല് കെ എം. http://libregeek.blogspot.com -- "Freedom is the only law". "Freedom Unplugged" http://www.ilug-tvm.org You received this message because you are subscribed to the Google Groups "ilug-tvm" group. To control your subscription visit http://groups.google.co.in/group/ilug-tvm/subscribe To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For details visit the google group page: http://groups.google.com/group/ilug-tvm?hl=en
