Re: Date & Time format..
- To: mathgroup at smc.vnet.net
- Subject: [mg107581] Re: Date & Time format..
- From: Bill Rowe <readnews at sbcglobal.net>
- Date: Thu, 18 Feb 2010 05:16:10 -0500 (EST)
On 2/17/10 at 7:01 AM, graser at gmail.com (graser) wrote:
>I have a list of date and time string such as..
>AA = {"Start", "Time", "11/4/2009", "3:24:06.505", "PM"}
>I want to read "11/4/2009", "3:24:06.505", "PM" as date format..
>so I did
>DateList["11/4/2009 3:24:06.505 PM"] and actually it gives me as
>{2009, 11, 4, 15, 24, 6.505}
>But there is also waring message like..
>** DateList::ambig: Warning: the interpretation of the string
>11/4/2009 3:24:06.505 PM as a date is ambiguous. >> ***
>So I thought the problem was "PM"
That is not the issue. The uncertainty is whether the "11/4"
portion of the string is a month followed by a day or a day
followed by a month.
>I tried it again with
>DateList[{"11/4/2009 3:24:06.505 PM", {"Day", "Month", "Year",
>"Hour", "Minute", "Second", "AMPM"}}]
>But it didn't work...
This doesn't work because what you told Mathematica to expect
doesn't match the format of the string. This works
In[9]:= DateList[{"11/4/2009 3:24:06.505 PM", {"Day", "Month", "Year",
"Hour", "Minute", "Second", "Millisecond", "AMPM"}}]
Out[9]= {2009,4,11,3,24,6.505}
and this works
In[10]:= DateList[{"11/4/2009 3:24:06 PM", {"Day", "Month", "Year",
"Hour", "Minute", "Second", "AMPM"}}]
Out[10]= {2009,4,11,3,24,6}