Hi You probably has zero hours in all your data
see > temp data_POSIX Sensor_code value 1 2002-11-01 00:00:00 1694 7.2 2 2002-11-01 00:00:00 1723 10.8 without hours > as.POSIXct(temp$data_POSIX, format = "%Y-%m-%d %H:%M:%S", tz="Etc/GMT-1") [1] "2002-11-01 +01" "2002-11-01 +01" add value to hours > fix(temp) > temp data_POSIX Sensor_code value 1 2002-11-01 00:01:00 1694 7.2 2 2002-11-01 00:00:00 1723 10.8 Voila, hours are back. > as.POSIXct(temp$data_POSIX, format = "%Y-%m-%d %H:%M:%S", tz="Etc/GMT-1") [1] "2002-11-01 00:01:00 +01" "2002-11-01 00:00:00 +01" So nothing wrong in uyour code, hours are there but they are probably not printed to console and hours are there but hidden. Cheers Petr > -----Original Message----- > From: R-help <r-help-boun...@r-project.org> On Behalf Of Stefano Sofia > Sent: Tuesday, November 30, 2021 9:20 AM > To: r-help mailing list <r-help@r-project.org> > Subject: [R] converting to POSIXct > > Dear R-list users, > I thought I was able to manage easily POSIXct, but this is not true. > I am not going to load the input txt file because I know that attachments are > not allowed. The structure of my input txt file is > > data_POSIX,Sensor_code,value > 2002-11-01 00:00:00,1694,7.2 > 2002-11-01 00:00:00,1723,10.8 > ... > > I load it with > myfile <- read.table(file="mypath/myfile.txt", header = TRUE, sep=",", dec = > ".", stringsAsFactors = FALSE) > > When I try to convert the data_POSIX column (which is a character) to > POSIXct with > > myfile$data_POSIX <- as.POSIXct(myfile$data_POSIX, format = "%Y-%m-%d > %H:%M:%S", tz="Etc/GMT-1") > > the outupt is > > 2002-11-01 1694 7.2 > 2002-11-01 1723 10.8 > ... > > Why I keep loosing hours, minutes and seconds? Wher eis my mistake or my > misunderstanding? > > Sorry again if I have not been able to reproduce the R code, and thank you > for your support. > Stefano > > (oo) > --oOO--( )--OOo-------------------------------------- > Stefano Sofia PhD > Civil Protection - Marche Region - Italy Meteo Section Snow Section Via del > Colle Ameno 5 > 60126 Torrette di Ancona, Ancona (AN) > Uff: +39 071 806 7743 > E-mail: stefano.so...@regione.marche.it > ---Oo---------oO---------------------------------------- > > ________________________________ > > AVVISO IMPORTANTE: Questo messaggio di posta elettronica può contenere > informazioni confidenziali, pertanto è destinato solo a persone autorizzate > alla ricezione. I messaggi di posta elettronica per i client di Regione Marche > possono contenere informazioni confidenziali e con privilegi legali. Se non > si è > il destinatario specificato, non leggere, copiare, inoltrare o archiviare > questo > messaggio. Se si è ricevuto questo messaggio per errore, inoltrarlo al > mittente ed eliminarlo completamente dal sistema del proprio computer. Ai > sensi dell’art. 6 della DGR n. 1394/2008 si segnala che, in caso di necessità > ed > urgenza, la risposta al presente messaggio di posta elettronica può essere > visionata da persone estranee al destinatario. > IMPORTANT NOTICE: This e-mail message is intended to be received only by > persons entitled to receive the confidential information it may contain. > E-mail > messages to clients of Regione Marche may contain information that is > confidential and legally privileged. Please do not read, copy, forward, or > store > this message unless you are an intended recipient of it. If you have received > this message in error, please forward it to the sender and delete it > completely from your computer system. > > -- > Questo messaggio stato analizzato da Libraesva ESG ed risultato non infetto. > This message was scanned by Libraesva ESG and is believed to be clean. > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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.
______________________________________________ R-help@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.