- Description: Returns the current date and time from the server.
- Purpose: Fetching system timestamp.
- Syntax:
SYSDATE - Parameters: None.
- Returns: Current date and time.
- Example:
SELECT SYSDATE FROM dual;returns the current timestamp. - Notes: The format is based on the database settings.
- Use Case: Timestamping records in logs.
Leave a Reply