Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2007
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2007

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: date format

  • To: mathgroup at smc.vnet.net
  • Subject: [mg75157] Re: date format
  • From: Albert <awnl at arcor.net>
  • Date: Wed, 18 Apr 2007 05:13:08 -0400 (EDT)
  • References: <f015bp$9sk$1@smc.vnet.net>

Hi,

> Form the following date format
> 
> 04/Dec/2006:19:54:02
> 
> could you please show me how to get the following representation {day,
> month, year, hour, minutes, seconds} - so exactly the same as for
> Date[]
> 

This is one way to do what you want:

monruls = {
     "Jan" -> 1, "Feb" -> 2, "Mar" -> 3,
     "Apr" -> 4, "May" -> 5, "Jun" -> 6, "Jul" -> 7,
     "Aug" -> 8, "Sep" -> 9, "Oct" -> 10, "Nov" -> 11,
     "Dec" -> 12
     };

Map[
     ToExpression,
     StringSplit[datestr, ":" | "/"] /. monruls
][[{3, 2, 1, 4, 5, 6}]]

it splits the string at : and /, then replaces the month with numbers, 
makes all the remaining string to numbers with ToExpression and finally 
sorts the entries as they appear in the Date format. If you really need 
that, you could turn the last entry for the seconds into a real with N, 
with the above code, it still is an integer which I think should be o.k. 
for most cases...

hth,

albert


  • Prev by Date: Re: LegendreP Evaluation Mystery
  • Next by Date: RE: date format
  • Previous by thread: Re: date format
  • Next by thread: open parenthesis and reduce an expression