What is the Difference between Datenow() function and SYSDATE in SQR?

What is the Difference between Datenow() function and SYSDATE in SQR?

Views: 852

Reply to This

Replies to This Discussion

Datenow() is an SQR function that is portable across DB platforms, Oracle, SQL server etc. SYSDATE is an Oracle DB function and does not work on other database platforms like SQL server. Best practice would be to use Datenow() to ensure your SQR is portable across database platforms.

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you. Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service