Lesson 34 GetDate, DatePart & DateDiff in SQL | SQL Database for Developer Course | IT Literacy
Lesson 34 - Some functions working with time | SQL Database for Developer
GETDATE() and GETUTCDATE() functions: Return the current time and time in UTC
DATENAME() and DATEPART() functions: return the time value of the input argument
DAY(), MONTH(), YEAR() functions: return the time value of the input argument
DATEADD() function: add to the time period
DATEDIFF() function: calculate the difference between 2 time values based on the specified time
#sqldatabase #sqldeveloper #sql #imictechnology #getdate_in_sql #datepart_in_sql #datediff_in_sql #dateadd_in_sql #xoamuit
📌 Please LIKE the video if you find it useful, SUBSCRIBE to the XoaMuIT channel so you don't miss other valuable learning and knowledge sharing videos.
💬 And don't forget to COMMENT below if you have any questions or want me to make more videos to fix other problems!
🔥 XoaMuIT - Learn for real, do for real, share for real!
👉 Copyright belongs to XoaMuIT.
👉 Copyright by XoaMuIT. Do not reup