DateTimeUTC
Overview
Gets the UTC/GMT date and time with an optional format string.
Prototype
String DateTimeUTC(string format = 'yyyy-MM-dd HH:mm:ss.ms')
Example
SELECT
DateTimeUTC() as UTCDateTime,
DateTimeUTC('mm/dd/yyyy') as 'Formatted Date',
DateTimeUTC('MM/dd/yyyy hh:mm:ss:ms') as 'Formatted Date/Time'
FROM
WordList:Word
WHERE
Text LIKE '%-gorge'Format Strings
| Format specifier | Description |
| d | The day of the month, from 1 through 31. |
| dd | The day of the month, from 01 through 31. |
| ddd | The abbreviated name of the day of the week. |
| dddd | The full name of the day of the week. |
| f | The tenths of a second in a date and time value. |
| ff | The hundredths of a second in a date and time value. |
| fff | The milliseconds in a date and time value. |
| ffff | The ten thousandths of a second in a date and time value. |
| fffff | The hundred thousandths of a second in a date and time value. |
| ffffff | The millionths of a second in a date and time value. |
| fffffff | The ten millionths of a second in a date and time value. |
| F | If non-zero, the tenths of a second in a date and time value. |
| FF | If non-zero, the hundredths of a second in a date and time value. |
| FFF | If non-zero, the milliseconds in a date and time value. |
| FFFF | If non-zero, the ten thousandths of a second in a date and time value. |
| FFFFF | If non-zero, the hundred thousandths of a second in a date and time value. |
| FFFFFF | If non-zero, the millionths of a second in a date and time value. |
| FFFFFFF | If non-zero, the ten millionths of a second in a date and time value. |
| g, gg | The period or era. |
| h | The hour, using a 12-hour clock from 1 to 12. |
| hh | The hour, using a 12-hour clock from 01 to 12. |
| H | The hour, using a 24-hour clock from 0 to 23. |
| HH | The hour, using a 24-hour clock from 00 to 23. |
| K | Time zone information. |
| m | The minute, from 0 through 59. |
| mm | The minute, from 00 through 59. |
| M | The month, from 1 through 12. |
| MM | The month, from 01 through 12. |
| MMM | The abbreviated name of the month. |
| MMMM | The full name of the month. |
| s | The second, from 0 through 59. |
| ss | The second, from 00 through 59. |
| t | The first character of the AM/PM designator. |
| tt | The AM/PM designator. |
| y | The year, from 0 to 99. |
| yy | The year, from 00 to 99. |
| yyy | The year, with a minimum of three digits. |
| yyyy | The year as a four-digit number. |
| yyyyy | The year as a five-digit number. |
| z | Hours offset from UTC, with no leading zeros. |
| zz | Hours offset from UTC, with a leading zero for a single-digit value. |
| zzz | Hours and minutes offset from UTC. |
| : | The time separator. |
| / | The date separator. |
| string | Literal string delimiter. |
| 'string' | More information: Character literals. |
| % | Defines the following character as a custom format specifier. |
| \ | The escape character. |
| Any other character | The character is copied to the result string unchanged. |
See also
Related