Date & Time format..
in [Mathematica]
|
Prev: Question about Plot[] algorythm.
Next: DDFLink
From: graser on 24 Feb 2010 06:20 On Feb 18, 5:16 am, Bill Rowe <readn...(a)sbcglobal.net> wrote: > On 2/17/10 at 7:01 AM, gra...(a)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} Hello, Thanks for your reply... But my question was 1. how to make Mathematica recognize AMPM situation It is not working with your methods 2. Yes.. how to clear the ambiguity.. either day/month or month/day...
From: Hans Michel on 25 Feb 2010 01:53 Graser: This combination did work after some trial and error. In[10]:= DateList[{"11/4/2009 3:24:06.303 PM",{"MonthShort","DayShort", "Year","Hour12Short","Minute","Second","MillisecondShort", "AMPM"}}] Out[10]= {2009,11,4,15,24,6.303} In[11]:= DateList[{"11/4/2009 3:24:06.303 PM",{"DayShort","MonthShort", "Year","Hour12Short","Minute","Second","MillisecondShort", "AMPM"}}] Out[11]= {2009,4,11,15,24,6.303} I think it has to do with taking into account the variable lengths and leading zeros of the digits in each element and upper or lower case. See the list of choices availabel for DateList and DateString "Date" full date "DateShort" full date, with short day and month names "Time" full time "DateTime" full date and time "DateTimeShort" full date and time, with short names "Year" full year (e.g. 2005) "YearShort" 2-digit year (e.g. 05) "QuarterName" quarter of year (e.g. "Quarter 1") "QuarterNameShort" quarter of year in short form (e.g. "Q1") "Quarter" quarter number (e.g. 1) "MonthName" month name (e.g. "August") "MonthNameShort" month name in short form (e.g. "Aug") "MonthNameInitial" first letter of month name (e.g. "A") "Month" 2-digit month number (e.g. 08) "MonthShort" 1- or 2-digit month number (e.g. 8) "DayName" day of the week (e.g. "Wednesday") "DayNameShort" day of the week in short form (e.g. "Wed") "DayNameInitial" first letter of day name (e.g. "W") "Day" 2-digit day of the month (e.g. 09) "DayShort" 1- or 2-digit day of the month (e.g. 9 or 29) "Hour" 2-digit hour based on system preferences "Hour12" 2-digit hour on 12-hour clock (e.g. 07) "Hour24" 2-digit hour on 24-hour clock (e.g. 19) "HourShort" 1- or 2-digit hour based on system preferences "Hour12Short" 1- or 2-digit hour on 12-hour clock (e.g. 7) "Hour24Short" 1- or 2-digit hour on 24-hour clock (e.g. 7, 19) "AMPM" AM or PM "AMPMLowerCase" am or pm "Minute" 2-digit minute (e.g. 05) "MinuteShort" 1- or 2-digit minute (e.g. 5 or 35) "Second" 2-digit seconds "SecondShort" 1- or 2-digit seconds "SecondExact" seconds including fractions "Millisecond" 3-digit milliseconds "MillisecondShort" 1-, 2- or 3-digit milliseconds Quit Kernel and started again In[1]:= DateList[{"11/4/2009 3:24:06.303 PM",{"MonthShort","DayShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] Out[1]= {2009,11,4,15,24,6.303} In[2]:= DateList[{"11/4/2009 3:24:06.303 PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] Out[2]= {2009,4,11,15,24,6.303} I tried a leading zero on the Month part to make certain that the presence or absence of a leading zero would not affect the conversion. If this is the case, seem a safer bet to chose the appropriate options with Short. In[3]:= DateList[{"11/04/2009 3:24:06.303 PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] Out[3]= {2009,4,11,15,24,6.303} version "7.0 for Microsoft Windows (32-bit) (November 10, 2008)" Also tried on In[1]:= DateList[{"11/4/2009 3:24:06.303 PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] Out[1]= {2009,4,11,15,24,6.303} In[2]:= $Version Out[2]= 7.0 for Microsoft Windows (64-bit) (November 11, 2008) Even if Mathematica failed here since Mathematica supports Regular Expressions there are many regex libraries for date time validation and groupings see http://regexlib.com/DisplayPatterns.aspx?cattabindex=4&categoryid=5&p=2 Michael Ashe stuff is well described. You may need to include the milliseconds parts. Hans "graser" <graser(a)gmail.com> wrote in message news:hm322l$m95$1(a)smc.vnet.net... > On Feb 18, 5:16 am, Bill Rowe <readn...(a)sbcglobal.net> wrote: >> On 2/17/10 at 7:01 AM, gra...(a)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} > > Hello, > > Thanks for your reply... > > But my question was > > 1. how to make Mathematica recognize AMPM situation > > It is not working with your methods > > 2. Yes.. how to clear the ambiguity.. > either day/month or month/day... >
From: Alexey Popkov on 25 Feb 2010 01:53 > 1. how to make Mathematica recognize AMPM situation The solution is DateList[{"11/4/2009 3:24:06.505 PM", {"Day", "Month", "Year", "Hour12Short", "Minute", "Second", "Millisecond", "AMPM"}}] >2. Yes.. how to clear the ambiguity.. >either day/month or month/day... There ia no any ambiguity. See: DateList[{"11/4/2009 3:24:06.505 PM", {"Month", "Day", "Year", "Hour12Short", "Minute", "Second", "Millisecond", "AMPM"}}]
From: DrMajorBob on 25 Feb 2010 17:35
Great. As usual, Help for DateList left out most of the options. There are 35 on your list, but Help shows only 12. Bobby On Thu, 25 Feb 2010 00:53:21 -0600, Hans Michel <hmichel(a)cox.net> wrote: > Graser: > > This combination did work after some trial and error. > > In[10]:= DateList[{"11/4/2009 3:24:06.303 PM",{"MonthShort","DayShort", > "Year","Hour12Short","Minute","Second","MillisecondShort", "AMPM"}}] > > Out[10]= {2009,11,4,15,24,6.303} > In[11]:= DateList[{"11/4/2009 3:24:06.303 PM",{"DayShort","MonthShort", > "Year","Hour12Short","Minute","Second","MillisecondShort", "AMPM"}}] > Out[11]= {2009,4,11,15,24,6.303} > > I think it has to do with taking into account the variable lengths and > leading zeros of the digits in each element and upper or lower case. > > See the list of choices availabel for DateList and DateString > > "Date" full date > "DateShort" full date, with short day and month names > "Time" full time > "DateTime" full date and time > "DateTimeShort" full date and time, with short names > "Year" full year (e.g. 2005) > "YearShort" 2-digit year (e.g. 05) > "QuarterName" quarter of year (e.g. "Quarter 1") > "QuarterNameShort" quarter of year in short form (e.g. "Q1") > "Quarter" quarter number (e.g. 1) > "MonthName" month name (e.g. "August") > "MonthNameShort" month name in short form (e.g. "Aug") > "MonthNameInitial" first letter of month name (e.g. "A") > "Month" 2-digit month number (e.g. 08) > "MonthShort" 1- or 2-digit month number (e.g. 8) > "DayName" day of the week (e.g. "Wednesday") > "DayNameShort" day of the week in short form (e.g. "Wed") > "DayNameInitial" first letter of day name (e.g. "W") > "Day" 2-digit day of the month (e.g. 09) > "DayShort" 1- or 2-digit day of the month (e.g. 9 or 29) > "Hour" 2-digit hour based on system preferences > "Hour12" 2-digit hour on 12-hour clock (e.g. 07) > "Hour24" 2-digit hour on 24-hour clock (e.g. 19) > "HourShort" 1- or 2-digit hour based on system preferences > "Hour12Short" 1- or 2-digit hour on 12-hour clock (e.g. 7) > "Hour24Short" 1- or 2-digit hour on 24-hour clock (e.g. 7, 19) > "AMPM" AM or PM > "AMPMLowerCase" am or pm > "Minute" 2-digit minute (e.g. 05) > "MinuteShort" 1- or 2-digit minute (e.g. 5 or 35) > "Second" 2-digit seconds > "SecondShort" 1- or 2-digit seconds > "SecondExact" seconds including fractions > "Millisecond" 3-digit milliseconds > "MillisecondShort" 1-, 2- or 3-digit milliseconds > > Quit Kernel and started again > > In[1]:= DateList[{"11/4/2009 3:24:06.303 > PM",{"MonthShort","DayShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] > Out[1]= {2009,11,4,15,24,6.303} > In[2]:= > DateList[{"11/4/2009 3:24:06.303 > PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] > Out[2]= {2009,4,11,15,24,6.303} > > I tried a leading zero on the Month part to make certain that the > presence > or absence of a leading zero would not affect the conversion. If this is > the > case, seem a safer bet to chose the appropriate options with Short. > > In[3]:= DateList[{"11/04/2009 3:24:06.303 > PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] > Out[3]= {2009,4,11,15,24,6.303} > > version > "7.0 for Microsoft Windows (32-bit) (November 10, 2008)" > > Also tried on > In[1]:= DateList[{"11/4/2009 3:24:06.303 > PM",{"DayShort","MonthShort","Year","Hour12Short","Minute","Second","MillisecondShort","AMPM"}}] > Out[1]= {2009,4,11,15,24,6.303} > In[2]:= $Version > Out[2]= 7.0 for Microsoft Windows (64-bit) (November 11, 2008) > > Even if Mathematica failed here since Mathematica supports Regular > Expressions there are many regex libraries for date time validation and > groupings > > see > http://regexlib.com/DisplayPatterns.aspx?cattabindex=4&categoryid=5&p=2 > > Michael Ashe stuff is well described. You may need to include the > milliseconds parts. > > Hans > > "graser" <graser(a)gmail.com> wrote in message > news:hm322l$m95$1(a)smc.vnet.net... >> On Feb 18, 5:16 am, Bill Rowe <readn...(a)sbcglobal.net> wrote: >>> On 2/17/10 at 7:01 AM, gra...(a)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} >> >> Hello, >> >> Thanks for your reply... >> >> But my question was >> >> 1. how to make Mathematica recognize AMPM situation >> >> It is not working with your methods >> >> 2. Yes.. how to clear the ambiguity.. >> either day/month or month/day... >> > > -- DrMajorBob(a)yahoo.com |