[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