Link to home
Start Free TrialLog in
Avatar of Michael
Michael

asked on

how to increment a date and time they are split in to fields


I need to do a sweep of a database and increment the start date time by x amount of hours. the hours to increment is derived in an earlier statement. basically i have two fields

START_DATE datetime
START_TIME datetime

I guess i need to cast them into a single field, increment it by the increment value and write it back, I would liked to achieve this in a single statement. Can anyone suggest how this statement might look?

Thanks in advance

Avatar of anandarajpandian
anandarajpandian
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of pivar
pivar
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial