Forum OpenACS Q&A: Re: Calendar

Imagine this "universe":

time_intervals:

id|interval_id| start_date          | end_date
-----------------------------------------------------------
n|  n        |2004-08-25 06:00:00+02|2004-08-2506:00:00+02

n= a number.

Well, my question -> How can i get the date and the hour split in start-date ? For example, If i want to show the date only.
It´s possible with the timestamptz type.

Thank you very much.

Supposing you're running postgresql and start_date and end_date are timestampz datatypes you could split date and time with something like this:

for date:

select start_date::DATE from time_intervals

for time:

select start_date::TIME from time_intervals

You could try a real example with acs_objects table in your oacs instalation: select creation_date::DATE from acs_objects

A good reading about dates and times in postgresql is http://techdocs.postgresql.org/techdocs/faqdatesintervals.php . it is a little outdated but still works :)