Functions: Date And Time Functions Part 1 | Engini.io
Master the handling of date and time data with Engini’s essential Date and Time functions! In this tutorial, we’ll cover key functions like UTCNOW, FORMATDATETIME, LOCALTIMENOW, CONVERTTOLOCALTIME, CONVERTTIMEZONE, ADDSECONDS, ADDMINUTES, and ADDHOURS. These functions will help you manage, manipulate, and format date and time information to suit your workflow needs.
Tutorial Breakdown:
Introduction 00:00
UTCNOW Function 00:49 – Learn how to retrieve the current time in Coordinated Universal Time (UTC) with the UTCNOW function.
FORMATDATETIME Function 01:20 – Discover how to format date and time values into a desired string format using the FORMATDATETIME function.
LOCALTIMENOW Function 01:59 – Get the current local time based on your system's settings with the LOCALTIMENOW function.
CONVERTTOLOCALTIME Function 02:35 – Convert UTC time into your local time zone with the CONVERTTOLOCALTIME function for better localization.
CONVERTTIMEZONE Function 03:14 – Seamlessly convert time from one time zone to another using the CONVERTTIMEZONE function.
ADDSECONDS Function 03:57 – Learn how to add seconds to a date or time value using the ADDSECONDS function for precise time adjustments.
ADDMINUTES Function 04:30 – See how to easily add minutes to your date or time with the ADDMINUTES function.
ADDHOURS Function 05:03 – Use the ADDHOURS function to quickly add hours to a specific date or time for advanced time calculations.
Visit https://engini.io for more resources and support. Feel free to reach out anytime!