How to pass Current System time in the target field?

[Former Member]

Hi Experts

kindly help me in mapping a field in which I have to map current system time.

I think there is no standard function for time like the date so do i write a UDF for the same or any other way an in case a UDF than please help in that.

Thanks

Aprajita

[former_member556603]

Hi Mathur,

kindly help me in mapping a field in which I have to map current system time.

I think there is no standard function for time like the date so do i write a UDF for the same or any other way an in case a UDF than please help in that.

Mathur no need to write UDF for that..

Use standard function Current date-------> In that (Target Format) u have to specify the time i.e: HHmmss

Thats it..... Noe use this function as u like...

Satya Kumar

[former_member193376]

Hi

Kindly update the thread or close the thread if your question is solved.

Thanks

Saiyog

[jayendradasari]

Hi

In Message Mapping, In functions we can find a function called current date(with time, Double click and edit) which returns current time(system time).

Regards

Jayendra Dasari

[former_member193376]

Hi

You dont have to write a UDF. Use the standard date function "current date" and set your time format to whatever.

there is an option to do that, double click on the date function and there you will have an option, i cant remember the option name .but its there. click that and you can set the time format and the seperator for your time.

Thanks

Saiyog

Edited by: Saiyog Gonsalves on Jul 26, 2008 8:23 AM

[Former Member]

Hi,

You have option for standard date function. It will satisfy your requirements.

Thanks,

Boopathi

[Former Member]

But I need current system time not the date.Can you please explain it in a more detail.

Thanks

[Former Member]

Hi,

Try like this way:

In standard Function Date:

Current Date (Double click the date function and assign target parameter as HHmmss) ---> Target

It returns current system time

Thanks.

Boopathi

Edited by: Boopathi Thangavel on Jul 26, 2008 8:39 AM