sqlstring: sqlstring generic

Description Usage Arguments Value Examples

Description

sqlstring generic

Usage

1

Arguments

x

object to sqlstring

tz

timezone

Value

sqlstring

Examples

1
2
3
4
5
6
  require(tidyverse) 
  mytbl <- tibble::tibble(c1 = c(1, 2, 3), c2 = c(1.1, 2.1, 3.1), c3 = c(1, NA_real_, 3),
    c4 = c('A', 'B', 'C') , c5 = c(Sys.time(), Sys.time(), Sys.time()), 
    c5 = c(Sys.Date(), NA, Sys.Date), c6 = c(NA, NA, NA))
 mytbl %>% mutate_all(funs(sqlstring))
 mytbl %>% mutate_all(funs(sqlstring), tz="US/Eastern") 

obarisk/sqltools documentation built on May 24, 2019, 11:52 a.m.