Обсуждение: extracting parts from date values

Поиск
Список
Период
Сортировка

extracting parts from date values

От
Hubert Palme
Дата:
Hi,

How can I extract parts (e.g. month or day) from date values?

--
Hubert Palme
palme@uni-wuppertal.de

Re: extracting parts from date values

От
Stephan Szabo
Дата:
You should be able to use date_part()
[date_part('month', <value>), date_part('day', <value>)]

On Sat, 3 Feb 2001, Hubert Palme wrote:

> Hi,
>
> How can I extract parts (e.g. month or day) from date values?