Date Time Functions - ANSI SQL ?
От | Gonzo Rock |
---|---|
Тема | Date Time Functions - ANSI SQL ? |
Дата | |
Msg-id | 3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net обсуждение исходный текст |
Ответы |
Re: Date Time Functions - ANSI SQL ?
|
Список | pgsql-sql |
Curious to know... Are all the date time functions described in the pgSQL docs are ANSI-SQL or pgSQL extensions? For Example in the Docs: ------------------------ 4.7.1. EXTRACT, date_part EXTRACT (field FROM source) The extract function retrieves sub-fields from date/time values, such as year or hour. source is a value expression thatevaluates to type timestamp or interval. (Expressions of type date or time will be cast to timestamp and can thereforebe used as well.) field is an identifier (not a string!) that selects what field to extract from the source value.The extract function returns values of type double precision. The following are valid values: day The day (of the month) field (1 - 31) SELECT EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 16 Thanks all,
В списке pgsql-sql по дате отправления: