Description
Resets the ISO datetime string to the beginning of the hour specified in the string.
Syntax
ISOToHour(datetime_string)
Examples
ISOToHour('2009-01-07T01:07:01.000Z')
returns 2009-01-07T01:00:00.000Z
Notes
The datetime_string must be in ISO 8601 date time format, otherwise the job will fail. See Using ISO 8601 date/time functions.
Return value datatype
String
Impact of null value
If input is null, returns null.