Re: Cast: timestamp to integer
От | Arjen van der Meijden |
---|---|
Тема | Re: Cast: timestamp to integer |
Дата | |
Msg-id | 003401c33104$88f9d350$3ac15e91@acm обсуждение исходный текст |
Ответ на | Re: Cast: timestamp to integer (Rory Campbell-Lange <rory@campbell-lange.net>) |
Список | pgsql-general |
Why not use EXTRACT ? Arjen > -----Oorspronkelijk bericht----- > Van: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] Namens Rory Campbell-Lange > Verzonden: donderdag 12 juni 2003 18:58 > Aan: Michal Durys > CC: pgsql-general@postgresql.org > Onderwerp: Re: [GENERAL] Cast: timestamp to integer > > > select cast(to_char(current_timestamp, 'd') as integer)/5; > > On 12/06/03, Michal Durys (joe@anime.com.pl) wrote: > > I'd like to convert timestamp and date fields to intergers. > > Unfortunately cast() says it's impossible: > -- > Rory Campbell-Lange > <rory@campbell-lange.net> > <www.campbell-lange.net> > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > http://archives.postgresql.org
В списке pgsql-general по дате отправления: