Displaying 20 results from an estimated 50000 matches similar to: "Ruby Dates - help"
2006 Oct 08
2
Select range of dates
Hello,
This is likely fairly silly question, and I apologize to whomever takes the
time to respond.
I am a relatively new user of R, on Windows XP, version 2.3.1.
Say I have a data table that looks like the following:
x
Date Location Amount Blue Green
1 01/01/2001 Central 1817 TRUE FALSE
2 01/02/2001 Central 20358 FALSE TRUE
3 05/08/2001 Central 16245 FALSE TRUE
4
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
Hi,
I tried to read xlsx files by "XLConnect" packages, but the dates are
one day earlier than it is supposed to be. I moved from California to
Taiwan (Eastern Asia), and it worked well in California, but not in Taiwan.
Even if I adjust my Mac time to California time zone, it gives the wrong
dates. I don't know which part of the setting (in RStudio or in my Mac?) I
should adjust.
2007 Feb 07
2
How to set TZID in DTSTART?
Hello all,
I am currently evaluating the vpim libraries and like them very much.
However there''s one thing I can''t get done: How can I set the TZID
parameter for DTSTART/END dates so my encoded ICS file looks
something like this:
BEGIN:VEVENT
...
DTSTART;TZID=Eastern Time:20071201T080000
DTEND;TZID=Eastern Time:20071207T110000
...
END:VEVENT
I managed
2017 Sep 23
0
"XLConnect" packages; Excel dates read incorrectly
Hi John,
It could be due to this:
https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel
Jim
On Sat, Sep 23, 2017 at 1:04 PM, John <miaojpm at gmail.com> wrote:
> Hi,
>
> I tried to read xlsx files by "XLConnect" packages, but the dates are
> one day earlier than it is supposed to be. I moved from California
2005 Nov 07
3
New Standard/Daylight time-change dates in rhel4u2 but not centos4.2?
>From a login on a machine with rhel4u2
I can execute the following commands and get
the indicated output:
date --date="Mar 25 15:00:00 UTC 2006"
Sat Mar 25 10:00:00 EST 2006
date --date="Mar 25 15:00:00 UTC 2007"
Sun Mar 25 11:00:00 EDT 2007
As you can see, the output differs for 2006 and 2007. That
indicates that rhel4u2 includes changes required by the
2017 Sep 23
2
"XLConnect" packages; Excel dates read incorrectly
Jim,
I don't see how that link could be related to John's issue. Symptoms
related to your link involve discrepancies of four years whereas John is
seeing discrepancies of one day.
John,
I do not see any attached files.
Regards
On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi John,
> It could be due to this:
>
>
2004 Mar 03
2
read.spss and time/date information
I don't use SPSS but following through on your detective work
can provide the likely answer.
First note that both date numbers are evenly divisible by the number
of seconds in a day, i.e. 24*60*60. This suggests that these numbers
are seconds since some origin.
Since we know "2003/02/11" corresponds to 13264300800 we deduce that
the origin must be
spss.orig <-
2020 Oct 01
3
timezone tests and R-devel
The return value of Sys.time() today with a timezone of US/Eastern is
unchanged between 4.0.3-patched and devel, but on devel the following test
fails
all.equal(x, as.POSIXlt(x))
with
x = Sys.time()
This means that devel does not complete make tests (failure on
tests/reg-tests-2.R)
It is entirely possible that it is an error on my end, I use
export TZ="US/Eastern"
but I have been
2009 Sep 18
1
as.POSIXct(as.Date()) independent of timezone
Dear R users,
I am struggling a bit with the converting dates to full POSIX timestamps, in
particular, I would like to somehow force the timezone to be local, i.e. the
output of
as.POSIXct(as.Date("2008-07-01")) should always be equal to "2008-07-01
00:00:00", is that achievable ? I tried to set the origin and the timezone,
neither of which seems to make a difference.
On my Mac
2020 Oct 02
2
timezone tests and R-devel
Yes, the potential issue I see is that
make check
fails when I explicitly set TZ. However, I set it to be the same as what
the system reports when I login.
Details: The system (RHEL) I am working on has
$ strings /etc/localtime | tail -n 1
EST5EDT,M3.2.0,M11.1.0
$ date +%Z
EDT
$ echo $TZ
US/Eastern
On Fri, Oct 2, 2020 at 9:48 AM Sebastian Meyer <seb.meyer at fau.de> wrote:
> Thank
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
Hi John,
I was able to reproduce your problem in my environment.
I modified the statement
date11<-as.Date(a_col$date, format="%Y-%m-%d")
to
date11<-as.Date(as.POSIXlt(a_col$date),format="%Y-%m-%d")
which then gives the output you would like to see (at least on my system)
> date11
[1] "2004-01-01" "2004-01-02" "2004-01-05"
2006 Mar 14
5
Indiana timezone changing
I have a couple questions... I am in Indiana and our time zone is changing.
I used to choose America/Indiana/Indianapolis as the zone and we are
changing
to Eastern.
Question 1) Is there a command line only way to change my timezone?
I dont have access to X to run system-config-time. Doing a
"system-config-time --help"
or "system-config-time -h" did not give any information.
2017 Sep 24
3
"XLConnect" packages; Excel dates read incorrectly
Hi,
Thank you for all your responses.
For Eric, The files are attached. (I believe it was also attached in my
first message)
For David, Could you send me the link regarding possible solutions or a
more comprehensive description of the problem?
Thanks,
John
2017-09-23 22:29 GMT-07:00 David Winsemius <dwinsemius at comcast.net>:
>
> > On Sep 23, 2017, at 6:30 AM,
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote:
>
> Jim,
> I don't see how that link could be related to John's issue. Symptoms
> related to your link involve discrepancies of four years whereas John is
> seeing discrepancies of one day.
>
The MS Excel starting point was off by one day. R does not repeat that error. MS claims that
2003 Jul 31
4
timezones
I have some questions and comments on timezones.
Problem 1.
# get current time in current time zone
> (now <- Sys.time())
[1] "2003-07-29 18:23:58 Eastern Daylight Time"
# convert this to GMT
> (now.gmt <- as.POSIXlt(now,tz="GMT"))
[1] "2003-07-29 22:23:58 GMT"
# take difference
> now-now.gmt
Time difference of -5 hours
Note that the difference
2005 Nov 07
1
New Standard/Daylight time-change dates in rhel4u2 butnot centos4.2?
Which is why I always symlink /etc/localtime Not only does it solve
these issues, but it makes it very clear which timezone is selected!
-----Original Message-----
From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] On
Behalf Of Aleksandar Milivojevic
Sent: Monday, November 07, 2005 2:45 PM
To: centos at centos.org
Subject: Re: [CentOS] New Standard/Daylight time-change
2006 Mar 14
7
Application error (Rails)
After I attempted to add ActionMailer functionality, it gave the
"Application error (Rails)" and now, everything on my site works, except
for the part where the Actionmailer ''would have'' sent the email.
I took that out now, re-uploaded the file, and ran "killall -USR1
dispatch.fcgi" and still nothing. Everything else works, except that.
Any idea what
2005 Dec 05
1
need help with matrix manipulation
I hope my problem is not too basic to post here. I am a beginner having
problems with some matrix manipulation. The data I am working with are
sites with hourly ozone readings and is in a matrix where each row is a site
and each column is an hourly reading. So for 10 sites, one day's worth of
data is a 10x24 matrix - column 1 is the ozone measurement for midnight GMT,
column 2 is ozone at
2004 Nov 01
1
Time zone info problems...
Hi,
Installed Caesar 3 this morning under wine-20041019. C3 has worked
for a long time, but doesn't work under this version due to, of all
things, time zone information that's missing???
caesar@flash caesar $ wine .wine/drive_c/SIERRA/Caesar3/c3.exe
fixme:ntdll:TIME_GetTZAsStr Can't match system time zone name "PST" to
an entry in TZ_INFO
fixme:ntdll:TIME_GetTZAsStr
2006 Apr 17
1
Tick mark alignment for POSIXct data
I am using POSIXct objects to store my date/time information. If I am
plotting less that 2 days worth of data, I get the correct tick marks on the
x-axis which is showing the 'day HH:MM' and these line up with the data
points.
If the data spans more than 2 days, the tick marks are now off. In the data
below, I am creating some sample data and plotting the points. I am in the
Eastern