Sponsored Topics. For geographic and demographic information on the census-designated place Bridgewater, please see the article Bridgewater (CDP), Massachusetts. The Town of Bridgewater is a city in Plymouth County, Massachusetts, United States, 28 miles (43 km) south of Boston. At the 2000 Census, the population was 25,185.
User-defined functions combine the advantages of stored procedures with the capabilities of SQL predefined functions. They can accept parameters, perform specific calculations based on data retrieved by one or more SELECT statement, and return results directly to the calling SQL statement.
Answer: One of the confounding problems with Oracle SQL is the SYSDATE function. The purpose of SYSDATE is simply to return the current date and time associated with the OS on which the database in question resides. The returned value of SYSDATE is of the datatype: DATE. The format of the value returned by SYSDATE is determined by the nls_date_format initialization parameter. When using distributed SQL statements, the SYSDATE function returns the date and time that are set for the operating system of the local database.