What is the difference between ''Sysdate and now function''
CONTENT QUALITY ANSWER NEEDED.
Answers
Answered by
3
Now() function gives us the current date & time of when you entered the function whereas Sysdate() function gives the date and time after the code is executed. You can basically see the difference using sleep() function too.
Attachments:
Answered by
11
Sysdate and time are functions which are used in databases like Mysql.
Short note on Sysdate and now:
(1) Sysdate() and now() returns the output in date format.
(2) Sysdate() returns the time at which the program executes. Now() returns the time when the particular program has started.
(3) Sysdate() can store the date value on Timestamp. Now() can store on all time fields.
Hope this helps!
Short note on Sysdate and now:
(1) Sysdate() and now() returns the output in date format.
(2) Sysdate() returns the time at which the program executes. Now() returns the time when the particular program has started.
(3) Sysdate() can store the date value on Timestamp. Now() can store on all time fields.
Hope this helps!
Similar questions
Social Sciences,
7 months ago
Math,
7 months ago
Social Sciences,
1 year ago
Math,
1 year ago
Physics,
1 year ago
History,
1 year ago