Adam DeVita <adev...@...> writes: > [...] > > If I have to generate the date dimension on my own, I'm hoping to use > something like > create table date_dimension ( > [Dateid] integer primary key, > [Real_Year] int , > [Month_name] text, > [Day] int , > [QuarterNumber] int, > [DayofWeek_name] text, > [dayofYear] int, > [epoch_day] int, > [julian_day] int > ); >
[...] Why don't you simply use a spreadsheet program like OpenOfice Calc or Excel to prepare the table data for your fixed timespan (2010 - 2030) and import the whole thing? Would be a work of a few minutes ;-) greetings Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
