我的书签
添加书签
移除书签Syntax
提取DATETIME某个指定单位的值。单位可以为year, month, day, hour, minute或者second
extract
extract
- Doris 介绍
- Release notes
- SQL 手册
- SQL 函数
- DIGITAL-MASKING
- width_bucket
- CAST
- Bitmap 函数
- bitmap_subset_in_range
- bitmap_empty
- bitmap_hash
- to_bitmap
- bitmap_not
- intersect_count
- bitmap_max
- bitmap_and_count
- bitmap_subset_limit
- bitmap_contains
- bitmap_or
- bitmap_to_string
- bitmap_union
- bitmap_min
- bitmap_xor
- bitmap_intersect
- bitmap_has_any
- bitmap_xor_count
- bitmap_to_array
- bitmap_and_not
- orthogonal_bitmap_intersect_count
- bitmap_count
- bitmap_has_all
- bitmap_from_array
- bitmap_or_count
- bitmap_from_string
- orthogonal_bitmap_union_count
- orthogonal_bitmap_intersect
- sub_bitmap
- bitmap_hash64
- bitmap_and_not_count
- bitmap_and
- Bitwise 函数
- Hash 函数
- HLL 函数
- JSON 函数
- 分析（窗口）函数
- WINDOW-FUNCTION-SUM
- WINDOW-FUNCTION-LAG
- WINDOW-FUNCTION-ROW_NUMBER
- WINDOW-FUNCTION-WINDOW-FUNNEL
- WINDOW-FUNCTION-FIRST_VALUE
- WINDOW-FUNCTION-AVG
- WINDOW-FUNCTION-COUNT
- WINDOW-FUNCTION-NTILE
- WINDOW-FUNCTION-LEAD
- WINDOW-FUNCTION-RANK
- WINDOW-FUNCTION-LAST_VALUE
- WINDOW-FUNCTION-MAX
- WINDOW-FUNCTION-MIN
- WINDOW-FUNCTION-DENSE_RANK
- 窗口函数
- 加密和信息摘要函数
- 地理位置函数
- 字符串函数
- extract_url_parameter
- split_by_string
- hex
- bit_length
- mask
- sleep
- mask_last_n
- reverse
- right
- instr
- from_base64
- starts_with
- left
- replace
- split_part
- unhex
- multi_search_all_positions
- null_or_empty
- ascii
- parse_url
- space
- rtrim
- substr
- locate
- lower
- initcap
- find_in_set
- rpad
- sub_replace
- ltrim
- strleft
- esquery
- strright
- substring_index
- concat_ws
- length
- append_trailing_char_if_absent
- field
- lcase
- char_length
- repeat
- upper
- substring
- elt
- mask_first_n
- ends_with
- convert_to
- money_format
- not_null_or_empty
- ucase
- to_base64
- uuid
- multi_match_any
- trim
- concat
- lpad
- 模糊匹配
- 正则匹配
- 数学函数
- 数组函数
- array_avg
- array_position
- array_slice
- array_size
- array_contains
- element_at
- array_remove
- array_intersect
- array_product
- array_difference
- array_range
- array_compact
- countequal
- array_sum
- array_popback
- array_with_constant
- array
- array_max
- array_enumerate
- array_distinct
- array_sort
- array_union
- array_except
- arrays_overlap
- array_join
- array_min
- 日期函数
- time_round
- current_timestamp
- years_add
- dayname
- hours_add
- weeks_sub
- weekday
- hour
- extract
- seconds_diff
- year
- hours_diff
- from_unixtime
- convert_tz
- days_add
- years_sub
- to_date
- day
- to_days
- month
- hours_sub
- months_add
- weekofyear
- seconds_add
- yearweek
- date_trunc
- datediff
- timestampadd
- week
- dayofyear
- days_diff
- localtime,localtimestamp
- months_diff
- last_day
- seconds_sub
- minutes_sub
- utc_timestamp
- unix_timestamp
- date_format
- to_monday
- minutes_diff
- quarter
- months_sub
- dayofweek
- minute
- second
- weeks_add
- dayofmonth
- date_sub
- date_add
- monthname
- str_to_date
- years_diff
- from_days
- now
- minutes_add
- days_sub
- weeks_diff
- curdate,current_date
- curtime,current_time
- timediff
- makedate
- timestampdiff
- 条件函数
- 聚合函数
- MAX_BY
- GROUPING
- SEQUENCE-MATCH
- MIN_BY
- PERCENTILE_APPROX
- COLLECT_LIST
- BITMAP_UNION
- group_bit_or
- ANY_VALUE
- STDDEV,STDDEV_POP
- PERCENTILE_ARRAY
- TOPN_ARRAY
- MIN
- COLLECT_SET
- VAR_SAMP,VARIANCE_SAMP
- HLL_UNION_AGG
- TOPN
- GROUPING_ID
- group_bitmap_xor
- SUM
- APPROX_COUNT_DISTINCT
- VARIANCE,VAR_POP,VARIANCE_POP
- group_bit_and
- GROUP_CONCAT
- SEQUENCE-COUNT
- AVG
- group_bit_xor
- COUNT
- RETENTION
- PERCENTILE
- STDDEV_SAMP
- AVG_WEIGHTED
- TOPN_WEIGHTED
- MAX
- 表函数
- SQL 手册
- DDL
- DML
- Operators
- Show
- SHOW-DATABASES
- SHOW-VIEW
- SHOW-PLUGINS
- SHOW-ROUTINE-LOAD
- SHOW-TRASH
- SHOW-PROPERTY
- SHOW-ROUTINE-LOAD-TASK
- SHOW-FUNCTIONS
- SHOW-EXPORT
- SHOW-TABLET
- SHOW-CREATE-ROUTINE-LOAD
- SHOW-PROCESSLIST
- SHOW-DATA-SKEW
- SHOW-STREAM-LOAD
- SHOW-LOAD
- SHOW-CREATE-MATERIALIZED-VIEW
- SHOW-DELETE
- SHOW-VARIABLES
- SHOW-BROKER
- SHOW-CATALOGS
- SHOW-CREATE-CATALOG
- SHOW-WARNING
- SHOW-TABLETS
- SHOW-BACKENDS
- SHOW-BACKUP
- SHOW-OPEN-TABLES
- SHOW-GRANTS
- SHOW-SNAPSHOT
- SHOW-COLLATION
- SHOW-FILE
- SHOW-REPOSITORIES
- SHOW-DATABASE-ID
- SHOW-TABLES
- SHOW-TYPECAST
- SHOW-DYNAMIC-PARTITION
- SHOW-CHARSET
- SHOW-FRONTENDS
- SHOW-MIGRATIONS
- SHOW-ENCRYPT-KEY
- SHOW-PARTITIONS
- SHOW-COLUMNS
- SHOW-TRIGGERS
- SHOW-ALTER
- SHOW-ROLLUP
- SHOW-WHITE-LIST
- SHOW-ROLES
- SHOW-ENGINES
- SHOW-DATA
- SHOW-SQL-BLOCK-RULE
- SHOW-LOAD-PROFILE
- SHOW-SYNC-JOB
- SHOW-INDEX
- SHOW ALTER TABLE MATERIALIZED VIEW
- SHOW-PROC
- SHOW-QUERY-PROFILE
- SHOW-TABLE-ID
- SHOW-STATUS
- SHOW-SMALL-FILES
- SHOW-PROCEDURE
- SHOW-PARTITION-ID
- SHOW-TABLE-STATUS
- SHOW-CREATE-TABLE
- SHOW-LAST-INSERT
- SHOW-TRANSACTION
- SHOW-CREATE-FUNCTION
- SHOW-POLICY
- SHOW-RESTORE
- SHOW-RESOURCES
- SHOW-LOAD-WARNINGS
- SHOW-CREATE-DATABASE
- SHOW-EVENTS
- SHOW-CATALOG-RECYCLE-BIN
- 数据库管理
- ADMIN-SHOW-REPLICA-STATUS
- ADMIN-CLEAN-TRASH
- ADMIN-REBALANCE-DISK
- ADMIN-SET-REPLICA-STATUS
- ADMIN-CANCEL-REBALANCE-DISK
- INSTALL-PLUGIN
- SET-VARIABLE
- ADMIN-SET-CONFIG
- ADMIN-COPY-TABLET
- ADMIN-REPAIR-TABLE
- ADMIN DIAGNOSE TABLET
- RECOVER
- ADMIN-CANCEL-REPAIR
- ADMIN-SHOW-CONFIG
- ENABLE-FEATURE
- ADMIN SHOW TABLET STORAGE FORMAT
- UNINSTALL-PLUGIN
- ADMIN-CHECK-TABLET
- KILL
- ADMIN-SHOW-REPLICA-DISTRIBUTION
- 数据类型
- 账户管理
- 辅助命令
- 集群管理
- ALTER-SYSTEM-DECOMMISSION-BACKEND
- ALTER-SYSTEM-MODIFY-BACKEND
- ALTER-SYSTEM-DROP-OBSERVER
- ALTER-SYSTEM-ADD-BACKEND
- ALTER-SYSTEM-MODIFY-BROKER
- ALTER-SYSTEM-ADD-FOLLOWER
- CANCEL-ALTER-SYSTEM
- ALTER-SYSTEM-ADD-BROKER
- ALTER-SYSTEM-ADD-OBSERVER
- ALTER-SYSTEM-DROP-BACKEND
- ALTER-SYSTEM-DROP-BROKER
- ALTER-SYSTEM-DROP-FOLLOWER
- SQL 函数
- 安装部署
- 常见问题
- 快速开始
- 性能测试
- 数据操作
- 数据湖分析
- 数据表设计
- 生态扩展
- 管理手册
- 查询分析
- SQL拦截
- 性能优化
- 多租户和资源划分
- 链路追踪
- HTTP API
- SHOW DATA
- MIGRATE SINGLE TABLET TO A PARTICULAR DISK
- GET LABEL STATE
- RESTORE TABLET
- CANCEL LABEL
- PAD ROWSET
- QUERY DETAIL
- get\_log\_file
- Compaction Action
- PROFILE
- 检查和重置连接缓存
- GET TABLETS ON A PARTICULAR BE
- GET TABLETS DISTRIBUTION BETWEEN DIFFERENT DISKS
- CONNECTION
- CHECK ALL TABLET SEGMENT LOST
- FE
- Cancel Load Action
- Logout Action
- HA Action
- Get Load Info Action
- Hardware Info Action
- Session Action
- Bootstrap Action
- Upload Action
- Connection Action
- Statement Execution Action
- Query Profile Action
- Get DDL Statement Action
- Check Decommission Action
- Table Schema Action
- Meta Replay State Action
- Show Meta Info Action
- Meta Action
- Health Action
- Get FE log file
- Show Data Action
- Show Runtime Info Action
- Query Schema Action
- Log Action
- Profile Action
- Get Load State
- Table Query Plan Action
- System Action
- Set Config Action
- Meta Info Action
- Table Row Count Action
- Get Small File Action
- Show Proc Action
- Check Storage Type Action
- Query Detail Action
- Row Count Action
- Config Action
- Backends Action
- MANAGER
- System Table
- 内存管理
- 数据管理
- 用户权限及认证
- 运维监控
- 配置管理
- 集群管理
- 进阶使用
暂无相关搜索结果！
本文档使用 全库网 构建
