Apache Pig Todate() function issue

Question

I am converting a date string to datetime format in Pig using Todate function, but it is spitting out the wrong month.

input date = "2014-04-15 01:25:33.583Z" I am loading this as chararray
usage: ToDate(Timestamp,'YYYY-MM-DD HH:mm:ss.SSS')
output : 2014-01-15T01:25:33.583Z

Any idea as to why this could be happening.

I found the mistake. The format was wrong. – cryp Apr 19 '14 at 16:30 — cryp, Apr 19 '14 at 16:30
what was the correct format ? – Romain Jouin Mar 28 '15 at 14:33 — Romain Jouin, Mar 28 '15 at 14:33

score 2 · Answer 1 · answered Apr 19 '15 at 19:56

2

The issues lies on the string format : the YYYY and DD should be in lowercase, while the months should stay in uppercase !

cf : https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

answered Apr 19 '15 at 19:56

Romain Jouin

4,448
3
49
79

score 0 · Answer 2 · answered Nov 08 '18 at 04:30

0

ToDate(Timestamp,'yyyy-MM-dd HH:mm:ss.SSS')

only month and hour format need to be in capital letter.

answered Nov 08 '18 at 04:30

Jithin K J

11
3

Apache Pig Todate() function issue

2 Answers2