Skip to content

Strange result for strptime with %p

8 messages · Marc Girondot, Peter Dalgaard, PIKAL Petr +3 more

Marc Girondot
# 
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
PIKAL Petr
# 
Hi

Maybe it is connected to
%I
Hours as decimal number (01?12).

Your input has hour as 00

Cheers
Petr
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/
Peter Dalgaard
# 
Nice catch, Petr:
[1] NA
[1] "2018-05-01 00:59:59 WIT"

-pd

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      PIKAL Petr
    

    

      
      #
    

  


  

      
Hi

Credit belongs to documentation. I picked it from it.

Cheers
Petr

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        
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/

  
  


  


      

    

    

      
      

        


  

        

      Rui Barradas
    

    

      
      #
    

  


  

      
Hello,

Or %H, it also works.

strptime("05/01/18 00:59:59 AM", format = ("%m/%d/%y %H:%M:%S %p"), 
tz="Asia/Jayapura")
#[1] "2018-05-01 00:59:59 WIT"


Hope this helps,

Rui Barradas

?s 15:20 de 02/10/2018, PIKAL Petr escreveu:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

  
  


  


      

    

    

      
      

        


  

        

      Jeff Newmiller
    

    

      
      #
    

  


  

      
... except that the %p is ignored or generates an error (implementation-dependent) if you use %H, so this may only address a few of the values you are processing and then only on some platforms.

        
On October 2, 2018 8:22:02 AM PDT, Rui Barradas <ruipbarradas at sapo.pt> wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

        

      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      David Winsemius
    

    

      
      #
    

  


  

          

      
      
      
    

        
I'm afraid this is "as documented":

%I
Hours as decimal number (01?12).

I see no reason not to use "%H"

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      David Winsemius
    

    

      
      #
    

  


  

          

      
      
      
    

        
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 Winsemius
Alameda, CA, USA

'Any technology distinguishable from magic is insufficiently advanced.'   -Gehm's Corollary to Clarke's Third Law