date_trunc
date_trunc(text, timestamp), timestamp, Truncate to specified precision; see also Section 9.9.2, date_trunc('hour', timestamp '2001-02-16 20:38:40'), 2001-02-16 ... ,date_trunc( text , timestamp ), timestamp, Truncate to specified precision; see ... date_trunc('day', timestamptz '2001-02-16 20:38:40+00', 'Australia/Sydney') ...
| 相關軟體 PostgreSQL (64-bit) 資訊 | |
|---|---|
 date_trunc 相關參考資料
時間日期函數和操作符
date_trunc(text, timestamp), timestamp, 截斷成指定的精度；又見Section 9.9.2, date_trunc('hour', timestamp '2001-02-16 20:38:40'), 2001-02-16 20:00:00+00. http://twpug.net Documentation: 9.1: DateTime Functions and ... - PostgreSQL
date_trunc(text, timestamp), timestamp, Truncate to specified precision; see also Section 9.9.2, date_trunc('hour', timestamp '2001-02-16 20:38:40'), 2001-02-16 ... https://www.postgresql.org Documentation: 12: 9.9. DateTime Functions ... - PostgreSQL
date_trunc( text , timestamp ), timestamp, Truncate to specified precision; see ... date_trunc('day', timestamptz '2001-02-16 20:38:40+00', 'Australia/Sydney') ... https://www.postgresql.org Documentation: 11: 9.9. DateTime Functions ... - PostgreSQL
date_trunc( text , timestamp ), timestamp, Truncate to specified precision; see also Section 9.9.2, date_trunc('hour', timestamp '2001-02-16 20:38:40') ... https://www.postgresql.org Documentation: 10: 9.9. DateTime Functions ... - PostgreSQL
date_trunc( text , timestamp ), timestamp, Truncate to specified precision; see also Section 9.9.2, date_trunc('hour', timestamp '2001-02-16 20:38:40') ... https://www.postgresql.org PostgreSQL date_trunc() 截断日期函数,完成定时时间语法._ ...
3.date_trunc() 函数. select date_trunc('month',now()) +interval ' ... https://blog.csdn.net DATE_TRUNC 函数- Amazon Redshift
根据您指定的时间间隔（如小时、周或月）截断任何时间戳表达式或文本。 https://docs.aws.amazon.com DATE_TRUNC function - Amazon Redshift
The DATE_TRUNC function truncates a time stamp expression or literal based on the date part that you specify, such as hour, week, or month. DATE_TRUNC ... https://docs.aws.amazon.com DATE_TRUNC: A SQL Timestamp Function You Can Count On
Learn how to use Date_Trunc in SQL to round a timestamp to the interval you need. Aggregate time-based data with this helpful function. https://mode.com PostgreSQL DATE_TRUNC() function - w3resource
The date_trunc() function is used to truncate to specified precision. Syntax: date_trunc(text, timestamp). Return Type: timestamp. PostgreSQL ... https://www.w3resource.com |