Saturday 13 April 2013

SQL Functions: LAST_DAY

LAST_DAY:
Takes date as input and returns the last day of month corresponding to that date. Return type is always DATE.

Select LAST_DAY (LAST_ACCESS_DATE) FROM EMP;

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis