как преобразовать "2006-04-19 10:05:44.98593" -> "2006-04-19 10:05"

From: Serik <uge(at)pochtamt(dot)ru>
To: pgsql-ru-general <pgsql-ru-general(at)postgresql(dot)org>
Subject: как преобразовать "2006-04-19 10:05:44.98593" -> "2006-04-19 10:05"
Date: 2006-04-19 07:41:04
Message-ID: 200604190741.k3J7f4fQ022300@www9.pochta.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ru-general

есть функции для преобразования "2006-04-19 10:05:44.98593" -> "2006-04-19 10:05" ?

если конечно не делать ... EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40')+
EXTRACT(MONTH FROM TIMESTAMP '2001-02-16 20:38:40');

Serik Akhmetov

Responses

Browse pgsql-ru-general by date

  From Date Subject
Next Message sanya-spb 2006-04-19 08:30:11 Re: как преобразовать "2006-04-19 10:05:44.98593" -> "2006-04-19 10:05"
Previous Message Teodor Sigaev 2006-04-18 15:09:36 Re: Solaris 10 & tsearch2 & locale ru_RU.ANSI1251