How to force default timezone for as.Date

Asked Mar 30 '15 at 18:11

Active May 25 '18 at 09:33

Viewed 125 times

How to force R to have default timezone "Europe/Paris" on as.Date functions?

I tried:

Sys.setenv(tz='Europe/Paris') at the top of the script file - doesn't work

Would like to avoid adding a suffix tz="Europe/Paris" to every single as.Date call

EXAMPLE:

I have a function that pulls data from SQL database:

historyDateStart=toupper(format(as.POSIXlt(strptime(historyDateStart, "%d-%b-%y")),"%d-%b-%y"))

query=paste("SELECT price
FROM price_history
              WHERE date_field BETWEEN TO_DATE('",
              historyDateStart,
              "', 'dd-MON-yy') AND TO_DATE('",
              historyDateEnd,
              "', 'dd-MON-yy')
              ORDER BY date_field ",sep="")


  data=getoracledata(query,databaseName)

If I don't add tz="Europe/Paris" to as.Date functions then I'm getting data with time 23:00:00 & day before. That's even if I run the env.put before running this.

edited May 25 '18 at 09:33

zx8754

52,746
12
114
209

asked Mar 30 '15 at 18:11

LucasSeveryn

5,984
8
38
65

1

Who told you it didn't work? What `Sys.timezone()` or `Sys.time()` gives you? – David Arenburg Mar 30 '15 at 18:21
`"Date"` class objects don't have a time zone. – G. Grothendieck Mar 30 '15 at 18:26
1

@G.Grothendieck but `as.Date()` does, understandably, take a `tz=` argument – Josh O'Brien Mar 30 '15 at 18:28
Only `as.Date.POSIXct` but not in general. – G. Grothendieck Mar 30 '15 at 18:33
@DavidArenburg nobody told me, I tried it and all as.Date statements default to the windows timezone. – LucasSeveryn Mar 31 '15 at 10:05
How can you tell? Can you show an example? – David Arenburg Mar 31 '15 at 10:36
Hi David please see the edit – LucasSeveryn Mar 31 '15 at 15:02

How to force default timezone for as.Date

0 Answers0