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 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Who do I make _ not a wildcard?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Date Time Functions - ANSI SQL ?