localtimestamp returns the current date and time in the session time zone in a value of datatype TIMESTAMP. The difference between this function and current_timestamp is that localtimestamp returns a TIMESTAMP value while current_timestamp returns a TIMESTAMP WITH TIME ZONE value.