You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?
You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?
The function CURRENT_TIMESTAMP returns the current date and time from the user session with a data type of TIMESTAMP WITH TIME ZONE. SYSDATE returns the current date and time but with a DATE data type. LOCALTIMESTAMP returns the current date and time but with a data type of TIMESTAMP (without timezone). CURRENT_DATE returns the current date from the user session in the session's time zone, but with a DATE data type.
CURRENT_TIMESTAMP returns a timestamp data type with time zone
Correct is B
LOCALTIMESTAMP returns a TIMESTAMP value while CURRENT_TIMESTAMP returns a TIMESTAMP WITH TIME ZONE value B is correct