How to add specific time to the timedate field

[Anonymous]

Hi all

i have a Created field with like

CreatedDate,Value

1/13/2016 07:30 AM,40

1/14/2016 09:30 AM,120

i need to get

CreatedDate,Value

1/13/2016 09:00 AM,40

1/14/2016 11:30 AM,120

i.e i need to add 1:20 to the Created field

how to get this

Regards,

Mahesh

[sunny_talwar · Accepted solution]

Try this may be:

LOAD     TimeStamp(CreatedDate + (80/1440), 'M/DD/YYYY hh:mm TT') as CreatedDate,

               Value