Oracle

select now():
select to_char(sysdate, 'mm-dd-yyyy hh24:mi:ss') "now" from dual;

select last row:

select * from table where id = (select max(id) from table);