DAY()for the day of the month from a Date.DATETIME()for the DateTime from Date, DateTime, or Time.DATE()for the Date from Date, DateTime, or Time.For instance, to convert the current time-of-day to a Duration: TIMENOW() - "00:00:00". To convert a Time value to a Duration value, subtract another Time value. Note that each of HOUR(), MINUTE(), and SECOND() accept as input a Duration value, not a Time value. TOTALSECONDS() for count of seconds in Duration.TOTALMINUTES() for count of minutes in Duration.TOTALHOURS() for count of hours in Duration.TIME() for the Time from Date, DateTime, or Time.SECOND() for the second component of a specific Duration.MINUTE() for the minute component of a specific Duration.HOUR() for the hour component of a specific Duration.EXTRACTTIMES() to extract a list of Time values within a textual value.EXTRACTDURATIONS() to extract a list of Duration values within a textual value.For example, when the server evaluates security filters and workflow rules that include dates and times. The server uses the timezone of the user's device when performing time and date calculations. When the user's device contacts the server to read or update data, the device includes its timezone with the request. For example, if the timezone of the user's device is Pacific Standard Time (PST), the value returned is UTC-08:00 if the timezone of the user's device is Hong Kong, the value returned is UTC+8:00. The values returned by NOW(), TODAY(), and TIMENOW() reflect the timezone offset of the user's device.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |