Results 1 to 2 of 2

Thread: First date of last month

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    First date of last month

    Hello,
    I am looking or the function to pull the first day of last month.
    Is anybody can help me with this.

    I appreciate your help.

    LLL

  2. #2
    Join Date
    Mar 2003
    Location
    CA,USA
    Posts
    18
    LLL

    Here is your reply

    select last_day(add_months(sysdate,-2))+1 from dual;

    -ORACLE database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •