Date Time Format

[Former Member]

Hi Experts;

I want my date in the output in this format <b>yyyy-MM-dd HH:mm:ss.sss</b> .

This i think is not possible using standard functionality in graphical mapping.

How to do this.

Its quite urgent.Please help

Arjun Ghate

[Former Member · Accepted solution]

Hi ;

Try this out

This is a UDF .

java.util.Date d = new java.util.Date();

java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");

return f.format(d) ;

Mudit

[Former Member · Accepted solution]

Thanks it worked .

[Shabarish_Nair]

use this java code in a UDF;

Date now1 = new Date();

SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss.sss");

String dateString = formatter.format(now1);

return dateString;

ref: http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

[Former Member]

Hi Arjun,

in graphical mapping take source node field........take date function and double click it......change its format to yyyy-MM-dd HH:mm:ss.sss ..........then take it to target node.......

Thanks,

Rajeev Gupta

[Former Member]

Hi;

Tried this but we can take yyyy-MM-dd HH:mm:ss and not yyyy-MM-dd HH:mm:ss.sss using this.

Arjun