back end. 1  There are twenty-two men on it, thirteen at the front end, and nine at the back end. Rollo on the Rhine Jacob Abbott. 2  The third bomb fell into the back end of the shed, but I guessed it was not required. The Sequel George A. Taylor. 3  You could get behind the counter only by a swinging gate at the back end.
The GETDATE function produces the current date and time in SQL Server 2005 internal format for datetime values. GETDATE takes the null parameter ( ). Here is the result set. You can use GETDATE in designing a report to have the current date and time printed every time the report is produced. GETDATE is also useful for functions such as logging the time a transaction occurred on an account. You can use GETDATE anywhere to return the current system date. For example, you can use GETDATE as a default value for data entry, with a local variable, or comparing an order date to the current date.
For example, if you have the date in A1, you can get the last day of the month of the date with this formula: The 2nd argument of the EOMONTH function allows you to get the last day of the month in future or past months. The result is returned as a valid date. To get the last day of in the month two months after the date in A1, use: To get the last day of in the month 6 months before the date in A1, use: As an alternative, you can also use the DATE function to get the last day of the month: When you supply zero as the day argument to DATE, the date function will roll back one day into the previous month, to the last day of that month.