[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Re[2]: Formatting Dates in SQR V3 and Oracle



select last_day(sysdate) from dual;

Brian



Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Brian McGraw/Sonat)
Subject:  Re[2]: Formatting Dates in SQR V3 and Oracle




Anyone know a quick and easy way (without hard coding or using complex
algorithms) to determine the last day in a month???  Like the last day in
may is
31, and the last day in February is 28 unless it's a leap year....
clark