SESSION NAME: SQL Functions - 2.

QUESTION NAME:  Now Function - Scalar Function.


TABLE DESCRIPTION:
NOW(): The NOW() function returns the current system
date and time.

Syntax:
SELECT NOW() FROM table_name;

Table Name : emp

Columns

eid - Number
name - varchar
age - Number
salary - Number

Use now() function after salary column in the query.

CODE:
select EID, NAME, AGE, SALARY, NOW() from emp;