# EXTRACT\_TIMESTAMP

将日期或时间戳字符串转换为日期或时间戳，自动检测日期格式。

## 语法

```
EXTRACT_TIMESTAMP(datetime)
```

## 参数

| 名称 | 类型 | 描述 | 默认值 |
| --- | --- | --- | --- |
| 日期时间 | 字符串 | 将日期或时间戳字符串转换为日期或时间戳，自动检测日期格式。 |  |

## 返回

时间戳

***

## 示例

| 日期时间 | 输出 |
| --- | --- |
| "2017-09-25 22:11:00" | 时间戳 "2017-09-25 22:11:00" |
| "2017-09-25T22:11:12Z" | 时间戳 "2017-09-25 22:11:12" |
| "2017-09-25T22:11:12.1Z" | 时间戳 "2017-09-25 22:11:12.100" |
| "2017-09-25T22:11:12.12Z" | 时间戳 "2017-09-25 22:11:12.120" |
| "2017-09-25T22:11:12.123Z" | 时间戳 "2017-09-25 22:11:12.123" |
| "2018-03-19" | 时间戳 "2018-03-19 00:00:00" |
| "2018\_Mar\_21\_17:59:05.689" | 时间戳 "2018-03-21 17:59:05.689" |
| "2018\_Mar\_21" | 时间戳 "2018-03-21 00:00:00" |
| "2018\_Mar\_21\_00:59:05.689 America/Los\_Angeles" | 时间戳 "2018-03-21 07:59:05.689" |
| "March 21, 2018 00:59:05.689 America/Los\_Angeles" | 时间戳 "2018-03-21 07:59:05.689" |
| "03/21/2020 00:59:05.689" | 时间戳 "2020-03-21 00:59:05.689" |
| "03/11/2020 00:59:05.689 America/Los\_Angeles" | 时间戳 "2020-03-11 07:59:05.689" |
| "03/11/2020 00:59:05.689 America/Los\_Angeles" | 时间戳 "2020-03-11 07:59:05.689" |
| "21/11/2020 00:59:05.689 America/Los\_Angeles" | 时间戳 "2020-11-21 08:59:05.689" |
| "https://www.zillow.com/homedetails/33-Rohde-Ave-St-Augustine-FL-32084/2099072901\_zpid/" | 时间戳 "2099-07-29 01:00:00" |