Wie führe ich einen Zeitstempel ein und lasse ihn durchlaufen?

Hi there,

I ve been working on this problem for quite some time but havent been able to come up with a solution yet.

I ve got a tabel with data. For each data I want to introduce a date which then continues to go on with an intervall of one hour. The date should be in an additional column.

Example

2011-01-01 00:00:00 323

2011-01-01 01:00:00 344

2011-01-01 02:00:00 187

. . .

How do I fill the additional column with the dates?

Thanks a lot for your help!