SQL Eval Function DateTime
Represents an instant in time, typically expressed as a date and time of day.
| Name | Description | Example |
|---|---|---|
| DateTime_AddDays(currDate, value) | Returns a new DateTime that adds the specified number of days to the currDate. |
Try it |
| DateTime_AddMonths(currDate, value) | Returns a new DateTime that adds the specified number of months to the currDate. |
Try it |
| DateTime_AddYears(currDate, value) | Returns a new DateTime that adds the specified number of years to the currDate. |
Try it |
| DateTime_Age(startDate, endDate) | Returns an age in number of years between startDate and endDate. |
Try it |
| DateTime_DayOfWeek(currDate) | Returns the day of the week represented by currDate. |
Try it |
| DateTime_DayOfYear(currDate) | Returns the day of the year represented by currDate. |
Try it |
| DateTime_DaysInMonth(year, month) | Returns the number of days in the specified month and year. | Try it |
| DateTime_FromBinary(dateData) | Deserializes a 64-bit binary value and recreates an original serialized DateTime object. | Try it |
| DateTime_FromFileTime(fileTime) | Converts the specified Windows file time to an equivalent local time. | Try it |
| DateTime_FromFileTimeUtc(fileTime) | Converts the specified Windows file time to an equivalent UTC time. | Try it |
| DateTime_FromOADate(fileTime) | Converts the specified Windows file time to an equivalent UTC time. | Try it |
| DateTime_IsDaylightSavingTime(currDate) | Indicates whether currDate instance of DateTime is within the daylight saving time range for the current time zone. |
Try it |
| DateTime_IsLeapYear(year) | Returns an indication whether the specified year is a leap year. | Try it |
| DateTime_Now() | Returns a DateTime object that is set to the current date and time on this computer, expressed as the local time. | Try it |
| DateTime_Ticks(currDate) | Returns the number of ticks that represent the date and time of the currDate instance. |
Try it |
| DateTime_ToBinary(currDate) | Serializes the current DateTime object to a 64-bit binary value that subsequently can be used to recreate the DateTime object. | Try it |
| DateTime_Today() | Returns a DateTime object that is set to the today's date and the time component set to 00:00:00. | Try it |
| DateTime_ToFileTime(currDate) | Converts the value of the current DateTime object to a Windows file time. | Try it |
| DateTime_ToFileTimeUtc(currDate) | Converts the value of the current DateTime object to a Windows file time. | Try it |
| DateTime_ToLocalTime(currDate) | Converts the value of the current DateTime object to local time. | Try it |
| DateTime_ToLongDateString(currDate) | Converts the value of the current DateTime object to its equivalent long date string representation. | Try it |
| DateTime_ToLongTimeString(currDate) | Converts the value of the current DateTime object to its equivalent long time string representation. | Try it |
| DateTime_ToOADate(currDate) | Converts the value of this instance to the equivalent OLE Automation date. | Try it |
| DateTime_ToShortDateString(currDate) | Converts the value of the current DateTime object to its equivalent short date string representation. | Try it |
| DateTime_ToShortTimeString(currDate) | Converts the value of the current DateTime object to its equivalent short time string representation. | Try it |
| DateTime_ToString(currDate) | Converts the value of the current DateTime object to its equivalent string representation. | Try it |
| DateTime_ToStringWithFormat(currDate, format) | Converts the value of the current DateTime object to its equivalent string representation using the specified format and the formatting conventions of the current culture. | Try it |
| DateTime_ToUniversalTime(currDate) | Converts the value of the current DateTime object to Coordinated Universal Time (UTC) time. | Try it |
| DateTime_UtcNow() | Returns a DateTime object that is set to the current date and time on this computer, expressed as the Coordinated Universal Time (UTC) time. | Try it |