Michael Glaesemann wrote:
-->-Mensagem original-
-->De: Michael Glaesemann [mailto:[EMAIL PROTECTED]
-->Enviada em: segunda-feira, 4 de dezembro de 2006 19:44
-->Para: Alejandro Michelin Salomon ( Adinet )
-->Cc: Pgsql-General
-->Assunto: Re: [GENERAL] Problem work
On Dec 5, 2006, at 8:13 , Alejandro Michelin Salomon (( Adinet )) wrote:
This table has :
Inicial date
Inicial hour
Duration
Final Date
Final time
Final Date and Final time are calculate based in Inicial date,
Inicial hour, Duration.
But i only need 2006-12-05 from the resulting timest
On 4 Dec 2006 at 20:13, Alejandro Michelin Salomon ( Adinet ) wrote:
> But i only need 2006-12-05 from the resulting timestamp.
> How to cut only the date from this timestamp?
Use date_trunc() just to lop off the time part of the timestamp:
http://www.postgresql.org/docs/8.2/static/functions-
da
Hi :
I have some problems working with date and times, in my web page.
I have table with tasks.
This table has :
Inicial date
Inicial hour
Duration
Final Date
Final time
Final Date and Final time are calculate based in Inicial date, Inicial hour,
Duration.
In my test:
Inicial date 2000-
