http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
You need to use 'YYYY-MM-dd HH:mm:ss.SSS' instead of 'YYYY-MM-DD HH:mm:ss.SSS'. DD stands for day of the year and dd stands for day of the month. 11th day of the year can only be in January. So month always comes out as January. On Tue, May 17, 2016 at 4:02 AM, vikas Madhusudana <vikas...@gmail.com> wrote: > Hi, > > I have a date string "2016-05-11 23:59:57.628" > > I am using ToDate to parse the date ToDate($0, "YYYY-MM-DD HH:mm:ss.SSS); > > It is parsing the date as 2016-01-11T23:59:57.628-08:00 > > Month is parsed as 01 (Jan instead of May). > > Am i missing something here? > > Thanks, > Vikas >