In Oracle the datatype is just DATE, and you need to select SYSDATE instead of now(). Precision is down to the second, anything more than that and you should start storing numbers. You'll probably use the TO_DATE() and TO_CHAR() functions to manipulate them...

I'd store the date and have another column that maps the user's local timezone setting so that you can convert the time for display.