Hi,
thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution.
thanks in advance
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał:
> Use this integer sequence and interval datatype to get date result:
> your_date='1994-01-01'::date+'1 day'::integer * time_key
^^^^^^^
Sorry, use interval here.
Regards,
Tomasz Myrta
|
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 01/21/2004 04:53 PM | To: [EMAIL PROTECTED]
cc: Subject: [SQL] time series data |
Hi,
i want to create time table & the structure as below :
| Column | Type | Modifiers |
| time_key yr_id month_id month_desc day_id | integer integer integer text integer | not null default nextval('time_seq'::text) |
Example of data in time table:
| Time_key | yr_id | month_id | month_desc | day_id |
| 1999 | 1 | Jan | 1 | |
| 1999 | 1 | Jan | 2 | |
| 2000 | 1 | Jan | 1 |
time_key data will keep increment reading from sequence. i'm going to have a data from yr_id =1994 --> 2009 , month_id =1 -->12
and day_id =1 -->31 for each month. So is there any solution (using function, or else) that can give me the above data
in Postgresql??.
thanks in advance.
