PARSE_DATETIME
Analiza una cadena de caracteres de una marca de tiempo con una zona horaria usando el formato.
Sintaxis
PARSE_DATETIME(input, format)
Argumentos
| Nombre | Tipo | Descripción | Valor predeterminado |
|---|---|---|---|
| input | cadena de texto | ||
| format | cadena de texto |
Devuelve
Devuelve un valor timestamp.
Ejemplos
| input | format | Resultado |
|---|---|---|
| "2017-09-25 22:11:00" | "aaaa-MM-dd HH:mm:ss" | timestamp "2017-09-25 22:11:00" |
| "2018-03-19" | "aaaa-MM-dd" | timestamp "2018-03-19 00:00:00" |
| "2018_Mar_21" | "aaaa_MMM_dd" | timestamp "2018-03-21 00:00:00" |
| "2018_Mar_21_17:59:05.689" | "aaaa_MMM_dd_HH:mm:ss.SSS" | timestamp "2018-03-21 17:59:05.689" |
| "2012/02/22 12:34:56" | "A/MM/d HH:mm:ss" | timestamp "2012-02-22 12:34:56" |
| "01-06-2021" | "dd-MM-AAAA" | timestamp "2021-06-01 00:00:00" |
| "01-06-2021" | "MM-dd-AAAA" | timestamp "2021-01-06 00:00:00" |
| "2021-05-13 19:02:57.415006+01:00" | "AAAA-MM-dd HH:mm:ss.SSSSSSZ" | timestamp "2021-05-13 18:02:57.415" |