O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Some complex date formats

Java provides a wide range of date options that can be used to define date formats, but sometimes the options to choose for a particular date time string aren't immediately obvious.

Some date formats that may prove useful are as follows:

  • ISO 8601 with offset standard: This format contains date, time, and the offset from UTC, as well as the T character that designates the start of the time, for example, 2007-04-05T12:30:22-02:00.

    The pattern for this date and time format is yyyy-MM-dd'T'HH:mm:ssXXX.

  • Mtime pattern: The tFileProperties component returns a field named mtime_string that is a string representation of a date and time format, for example, Wed Mar 13 23:53:07 GMT 2013.

    The pattern for this date and time format is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required