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-12-04
Inicial hour 20:00
Duration 5 (Hours)
Final time = time '"Inicial Hour"' + interval '"Duration" hours'
Ex: Final Time is --> time '20:00' + interval '5 hours' ===> 01:00 ( OK )
The problem cames when i try to add the duration to Inicial date.
if i execute this select :
select '2006-12-04 20:00'::timestamp + interval '5 hours'
the result is ok ( 2006-12-05 01:00:00 )
But i only need 2006-12-05 from the resulting timestamp.
How to cut only the date from this timestamp?
Thanks in advance
Alejandro Michelin Salomon