Cast Date to Timestamp
CAST (<mydate> AS TIMESTAMP)
Create user
CREATE USER 'new_user' IDENTIFIED BY 'my_password';
GRANT ALL ON my_database TO 'new_user';
GRANT SELECT, INSERT ON other_database TO 'new_user';
Convert Date or Timestamp to UTC format
(SYS_EXTRACT_UTC(<mydate>)
Get the first non-null value
COALESCE (<value1>, <value2>)
is equivalent to:
CASE WHEN <value1>IS NOT NULL THEN <value1> ELSE <value2> END