Use Case-
Let say you want to convert string to date data type for a date value.
You can use tConvertType for this work. See below sample job...
our source sting date is "2014-11-04T10:43:26.627+0530" so for conversion we should use the date format "yyyy-MM-dd'T'HH:mm:ss.SSSZ".
here +0530 and "Z" represents the time zone.
Note: For the same date in MySQL we can use format "yyyy-MM-dd HH:mm:ss".
Following are the some valid general date patterns...
e.g. we have the date 2001-07-04 12:08:56, see the many variants...
Let say you want to convert string to date data type for a date value.
You can use tConvertType for this work. See below sample job...
our source sting date is "2014-11-04T10:43:26.627+0530" so for conversion we should use the date format "yyyy-MM-dd'T'HH:mm:ss.SSSZ".
here +0530 and "Z" represents the time zone.
Note: For the same date in MySQL we can use format "yyyy-MM-dd HH:mm:ss".
Following are the some valid general date patterns...
e.g. we have the date 2001-07-04 12:08:56, see the many variants...
Date and Time Pattern Result "yyyy.MM.dd G 'at' HH:mm:ss z"2001.07.04 AD at 12:08:56 PDT"EEE, MMM d, ''yy"Wed, Jul 4, '01"h:mm a"12:08 PM"hh 'o''clock' a, zzzz"12 o'clock PM, Pacific Daylight Time"K:mm a, z"0:08 PM, PDT"yyyyy.MMMMM.dd GGG hh:mm aaa"02001.July.04 AD 12:08 PM"EEE, d MMM yyyy HH:mm:ss Z"Wed, 4 Jul 2001 12:08:56 -0700"yyMMddHHmmssZ"010704120856-0700"yyyy-MM-dd'T'HH:mm:ss.SSSZ"2001-07-04T12:08:56.235-0700"yyyy-MM-dd'T'HH:mm:ss.SSSXXX"2001-07-04T12:08:56.235-07:00"YYYY-'W'ww-u"2001-W27-3
No comments:
Post a Comment