adding time & date

[tyekhan]

Hi,

I have a time & data field what I want to add the time & day in the following format,

201106124150

so I want the query to start with first column which I enter then the rest to go in order

YYYYMMDDHHMM

SO

SO I will enter the first one as 201107220900

then I want a query that does the rest in order.

e.g

201107220901
201107220902
201107220903
201107220904


201107220905
201107220906
201107220907
201107220908

and on so it will change the minutes so when it get to 201107220959 it will change to 201107221000

only want times between 9-8 & want it to go onto the following date to so 201107222200 then to go to 201107230900

[orange]

Why? If you tell us what your business requirement is, there may be other options available.