[R] timeDate with month designated by three letters.
Clint Bowman
clint at ecy.wa.gov
Tue Jul 19 23:40:02 CEST 2011
> strptime("04-MAY-11 1428",format="%d-%b-%y %H%M")
[1] "2011-05-04 14:28:00"
--
Clint Bowman INTERNET: clint at ecy.wa.gov
Air Quality Modeler INTERNET: clint at math.utah.edu
Department of Ecology VOICE: (360) 407-6815
PO Box 47600 FAX: (360) 407-7534
Olympia, WA 98504-7600
USPS: PO Box 47600, Olympia, WA 98504-7600
Parcels: 300 Desmond Drive, Lacey, WA 98503-1274
On Tue, 19 Jul 2011, mdkzone at aol.com wrote:
> Dear R Experts:
>
>
> I am trying to convert a date and time character field to timeDate where the month is presented as three letters, such as "JUN" for June, etc.
>
>
> This is an example of the full character field:
>
>
> "04-MAY-11 1428"
> What is the proper format syntax?
>
>
> I've tried
>
> timeDate("04-MAY-11 1428",format="%d-%m-%y %H%M")
> but only get
>
> GMT
> [1] [NA]
> If I change the month to a number as below, then it works, but that would require recoding of the data field.
>
>
>
> timeDate("04-05-11 1428",format="%d-%m-%y %H%M")
>
> gives
>
> GMT
> [1] [2011-05-04 14:28:00]
> which is correct. How do I get R to recognize the month as a 3 letter designator.
>
>
> Any recommendations you can provide would be greatly appreciated.
>
>
> Michael
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
More information about the R-help
mailing list