PDA

View Full Version : "scripts" for creating time tables ?



maxcsaucdk
02-24-2003, 05:04 AM
Hi!
Anyone here with some javacode or similar that creates a timedimension table based on existing data ?
e.g. I have a whole bunch of records with a timestamp and I would like to have generated a corresponding time table with Q1, day/night, etc. facts in it ....

sgwood
02-14-2005, 02:43 AM
In Postgres, I do this with a trigger on the table, which fills in the values using SQL date functions.
Sherman