How to increase current time by one hour

[badugu_sarika]

Hi ,

I am mapping current date function to a field at target side. The current time format is HHmmss.

But here I have to increase the current time to one hour and thne map to the target field.

How I be able to achieve this. UDF or any other way.

Regards,

$arika

[maheswarareddykonda · Accepted solution]

Hi Try this,

In case you want to use input field as current time then you can do like below

[badugu_sarika]

Hi ,

Thankyou evryone for your valuable comments

[maheswarareddykonda]

Hi,

if issue resolved , close the thread

[iaki_vila]

Hi Sarika,

You can do a UDF to add one hour (Calendar (Java Platform SE 7 )), with the calendar class you only need to set

  Calendar calendar = Calendar.getInstance();
  calendar.setTime(YOURTIMETAG);
  calendar.add(Calendar.HOUR, 1);
 return calendar.getTime().toString();

Regards.

[former_member182412]

Hi Sarika,

You can use below UDF.

Regards,

Praveen.