SYSDATE#

Intent:#

This Oracle function will return the current date and time. It is usually used in conjunction with another function

Parameters:#

NONE

Returns:#

Date/Time

Errors:#

None

Operations: #

Note that SYSDATE returns a complete Oracle date and Time stamp in the format specified in your registry setting for NLS_DATE_FORMAT (usually DD-Mon-YYYY). If you do not want to consider the time portion, you should use the TRUNC() function. You will likely want to use data conversion functions to get the masking that you are looking for – see below. For conversion functions and masks Example:

	SYSDATE

---

Notes #

Click to create a new notes page