date string into Timestamp hours only


Anybody suggest me.I am getting one date 

string,values of 24 prices from database.Each

price is the value of each hour in that day.

In pipelinein i am passing one date field,

24 price values.

But i want to get one date,24 hours,24 price 

values in the pipeline out.Any body has

logic for this how to do it.

      for example i am getting date

12/05/2002 from database.Price values are

1,2,3…24.In pipelineout i have to

display (12/05/2002,01:00:00,1),

(12/05/2002,02:00:00,2 ).Pl give me logic.