Dear members... are these results normal ?
For the first one, no problem. I expected this:
> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y
%I:%M:%S %p"),
tz="Asia/Jayapura")
[1] "2018-05-01 01:00:00 WIT"
For this one, it is ok also:
> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y
%I:%M:%S %p"),
tz="Asia/Jayapura")-1
[1] "2018-05-01 00:59:59 WIT"
But how to explain this ???
> strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y
%I:%M:%S %p"),
tz="Asia/Jayapura")
[1] NA
Thanks for your advices
Marc
______________________
R 3.5.1 on MacOS 10.14
> version
?????????????? _
platform?????? x86_64-apple-darwin15.6.0
arch?????????? x86_64
os???????????? darwin15.6.0
system???????? x86_64, darwin15.6.0
status
major????????? 3
minor????????? 5.1
year?????????? 2018
month????????? 07
day??????????? 02
svn rev??????? 74947
language?????? R
version.string R version 3.5.1 (2018-07-02)
nickname?????? Feather Spray
Hi Maybe it is connected to %I Hours as decimal number (01?12). Your input has hour as 00 Cheers Petr> -----Original Message----- > From: R-help <r-help-bounces at r-project.org> On Behalf Of Marc Girondot via > R-help > Sent: Tuesday, October 2, 2018 3:30 PM > To: R-help Mailing List <r-help at r-project.org> > Subject: [R] Strange result for strptime with %p > > Dear members... are these results normal ? > > For the first one, no problem. I expected this: > > > strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), > tz="Asia/Jayapura") > [1] "2018-05-01 01:00:00 WIT" > > For this one, it is ok also: > > > strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), > tz="Asia/Jayapura")-1 > [1] "2018-05-01 00:59:59 WIT" > > But how to explain this ??? > > > strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), > tz="Asia/Jayapura") > [1] NA > > Thanks for your advices > Marc > ______________________ > > R 3.5.1 on MacOS 10.14 > > > version > _ > platform x86_64-apple-darwin15.6.0 > arch x86_64 > os darwin15.6.0 > system x86_64, darwin15.6.0 > status > major 3 > minor 5.1 > year 2018 > month 07 > day 02 > svn rev 74947 > language R > version.string R version 3.5.1 (2018-07-02) > nickname Feather Spray > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.Osobn? ?daje: Informace o zpracov?n? a ochran? osobn?ch ?daj? obchodn?ch partner? PRECHEZA a.s. jsou zve?ejn?ny na: https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information about processing and protection of business partner?s personal data are available on website: https://www.precheza.cz/en/personal-data-protection-principles/ D?v?rnost: Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a podl?haj? tomuto pr?vn? z?vazn?mu prohl??en? o vylou?en? odpov?dnosti: https://www.precheza.cz/01-dovetek/ | This email and any documents attached to it may be confidential and are subject to the legally binding disclaimer: https://www.precheza.cz/en/01-disclaimer/
Nice catch, Petr:> strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura")[1] NA> strptime("05/01/18 12:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura")[1] "2018-05-01 00:59:59 WIT" -pd> On 2 Oct 2018, at 15:39 , PIKAL Petr <petr.pikal at precheza.cz> wrote: > > Hi > > Maybe it is connected to > %I > Hours as decimal number (01?12). > > Your input has hour as 00 > > Cheers > Petr > >> -----Original Message----- >> From: R-help <r-help-bounces at r-project.org> On Behalf Of Marc Girondot via >> R-help >> Sent: Tuesday, October 2, 2018 3:30 PM >> To: R-help Mailing List <r-help at r-project.org> >> Subject: [R] Strange result for strptime with %p >> >> Dear members... are these results normal ? >> >> For the first one, no problem. I expected this: >> >>> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), >> tz="Asia/Jayapura") >> [1] "2018-05-01 01:00:00 WIT" >> >> For this one, it is ok also: >> >>> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), >> tz="Asia/Jayapura")-1 >> [1] "2018-05-01 00:59:59 WIT" >> >> But how to explain this ??? >> >>> strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), >> tz="Asia/Jayapura") >> [1] NA >> >> Thanks for your advices >> Marc >> ______________________ >> >> R 3.5.1 on MacOS 10.14 >> >>> version >> _ >> platform x86_64-apple-darwin15.6.0 >> arch x86_64 >> os darwin15.6.0 >> system x86_64, darwin15.6.0 >> status >> major 3 >> minor 5.1 >> year 2018 >> month 07 >> day 02 >> svn rev 74947 >> language R >> version.string R version 3.5.1 (2018-07-02) >> nickname Feather Spray >> >> ______________________________________________ >> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. > Osobn? ?daje: Informace o zpracov?n? a ochran? osobn?ch ?daj? obchodn?ch partner? PRECHEZA a.s. jsou zve?ejn?ny na: https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information about processing and protection of business partner?s personal data are available on website: https://www.precheza.cz/en/personal-data-protection-principles/ > D?v?rnost: Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a podl?haj? tomuto pr?vn? z?vazn?mu prohl??en? o vylou?en? odpov?dnosti: https://www.precheza.cz/01-dovetek/ | This email and any documents attached to it may be confidential and are subject to the legally binding disclaimer: https://www.precheza.cz/en/01-disclaimer/ > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.-- Peter Dalgaard, Professor, Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Office: A 4.23 Email: pd.mes at cbs.dk Priv: PDalgd at gmail.com
> On Oct 2, 2018, at 6:30 AM, Marc Girondot via R-help <r-help at r-project.org> wrote: > > Dear members... are these results normal ? > > For the first one, no problem. I expected this: > > > strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura") > [1] "2018-05-01 01:00:00 WIT" > > For this one, it is ok also: > > > strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura")-1 > [1] "2018-05-01 00:59:59 WIT" > > But how to explain this ??? > > > strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura") > [1] NAI'm afraid this is "as documented": %I Hours as decimal number (01?12). I see no reason not to use "%H" -- David.> > Thanks for your advices > Marc > ______________________ > > R 3.5.1 on MacOS 10.14 > > > version > _ > platform x86_64-apple-darwin15.6.0 > arch x86_64 > os darwin15.6.0 > system x86_64, darwin15.6.0 > status > major 3 > minor 5.1 > year 2018 > month 07 > day 02 > svn rev 74947 > language R > version.string R version 3.5.1 (2018-07-02) > nickname Feather Spray > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.David Winsemius Alameda, CA, USA 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law
> On Oct 2, 2018, at 10:11 AM, David Winsemius <dwinsemius at comcast.net> wrote: > > >> On Oct 2, 2018, at 6:30 AM, Marc Girondot via R-help <r-help at r-project.org> wrote: >> >> Dear members... are these results normal ? >> >> For the first one, no problem. I expected this: >> >>> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura") >> [1] "2018-05-01 01:00:00 WIT" >> >> For this one, it is ok also: >> >>> strptime("05/01/18 01:00:00 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura")-1 >> [1] "2018-05-01 00:59:59 WIT" >> >> But how to explain this ??? >> >>> strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura") >> [1] NA > > I'm afraid this is "as documented": > > %I > Hours as decimal number (01?12). > > I see no reason not to use "%H"If you need to use %I and %p then you may need to pre-process with sub(" 00", " 12", object_name) strptime("05/01/18 12:59:59 AM", format = ("%m/%d/%y %I:%M:%S %p"), tz="Asia/Jayapura") [1] "2018-05-01 00:59:59 WIT"> > -- > David. >> >> Thanks for your advices >> Marc >> ______________________ >> >> R 3.5.1 on MacOS 10.14 >> >>> version >> _ >> platform x86_64-apple-darwin15.6.0 >> arch x86_64 >> os darwin15.6.0 >> system x86_64, darwin15.6.0 >> status >> major 3 >> minor 5.1 >> year 2018 >> month 07 >> day 02 >> svn rev 74947 >> language R >> version.string R version 3.5.1 (2018-07-02) >> nickname Feather Spray >> >> ______________________________________________ >> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.David Winsemius Alameda, CA, USA 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law