Re: ToDate does not parse the date properly

[vikas Madhusudana]

Thanks. Its working fine now.

Thanks,
Vikas

On Sat, May 28, 2016 at 3:10 AM, Rohini Palaniswamy  wrote:

> http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
>
> You need to use '-MM-dd HH:mm:ss.SSS' instead of  '-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 
> wrote:
>
> > Hi,
> >
> > I have a date string "2016-05-11 23:59:57.628"
> >
> > I am using ToDate to parse the date ToDate($0, "-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
> >
>

Re: ToDate does not parse the date properly

[Rohini Palaniswamy]

http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html

You need to use '-MM-dd HH:mm:ss.SSS' instead of  '-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 
wrote:

> Hi,
>
> I have a date string "2016-05-11 23:59:57.628"
>
> I am using ToDate to parse the date ToDate($0, "-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
>

ToDate does not parse the date properly

[vikas Madhusudana]

Hi,

I have a date string "2016-05-11 23:59:57.628"

I am using ToDate to parse the date ToDate($0, "-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