Unless specified otherwise, any method that return a Date/ Time value will remove any milliseconds from the time portion.
| Name | Description | |
|---|---|---|
| ConvertDatabaseToLocalDateTime | Convert the specified Database Date/Time into the Local Windows Time Zone. | |
| ConvertDatabaseToTimeZoneDateTime | Convert the specified Database Date/Time into the Time Zone specified. | |
| ConvertDatabaseToUtcDateTime | Convert the specified Database Date/Time into a UTC Date/Time (i.e., from the Database Time Zone specified under Global Settings). | |
| ConvertLocalToDatabaseDateTime | Convert the specified Local Date/Time into the Database Time Zone specified under Global Settings. | |
| ConvertLocalToUtcDateTime | Convert the specified Local Date/Time into a UTC Date/Time as per the current Windows computer. | |
| ConvertTimeZoneModifiedUtcToUtcDateTime System Use Only | Convert the specified 'modified' UTC Date/Time into a true UTC Date/Time for the specified Time Zone. | |
| ConvertTimeZoneToUtcDateTime | Convert the specified Date/Time in a specified Time Zone into a UTC Date/Time. | |
| ConvertUtcToDatabaseDateTime | Convert the specified UTC Date/Time into a Database Date/Time (i.e., to the Database Time Zone specified under Global Settings). | |
| ConvertUtcToLocalDateTime | Convert the specified UTC Date/Time into a Local Date/Time as per the current Windows computer. | |
| ConvertUtcToTimeZoneDateTime | Convert the specified UTC Date/Time into a Date/Time for the specified Time Zone. | |
| DatabaseTimeZone | Returns the current Database Time Zone (or Nothing if undefined). | |
| GetCurrentDatabaseDate | Returns the current Date without Time information (as retrieved from the database server if possible) adjusted to the database time zone configured under Global Settings. | |
| GetCurrentDatabaseDateTime | Returns the current Date/Time (as retrieved from the database server if possible) adjusted to the database time zone configured under Global Settings - Rounded to whole seconds. | |
| GetCurrentLocalDate | Returns the current Local Date (without Time information) as per the current Windows computer. | |
| GetCurrentLocalDateTime | Get the current Local Date/Time as per the current Windows computer - Rounded to whole seconds. | |
| GetCurrentTimeZoneDate | Returns the current Date without Time information (as retrieved from the database server if possible) adjusted to the specified time zone. | |
| GetCurrentTimeZoneDateTime | Returns the current Date/Time (as retrieved from the database server if possible) adjusted to the specified time zone - Rounded to whole seconds.. | |
| GetCurrentUtcDateTime | Returns the current UTC Date/Time (as retrieved from the database server if possible) - Rounded to whole seconds. | |
| GetCurrentUtcDateTimePrecise | Returns the current UTC Date/Time (as retrieved from the database server if possible) - including fractions of a second. | |
| GetTimeZoneDescriptionFromTimeZoneId | Gets the Time Zone Description from a Time Zone Id. |