date_between: Create SQL string to select date between two given dates
In UweBlock/lazysql: Lazy SQL Programming

Description Usage Arguments Details Value Author(s) See Also Examples

Create string with SQL BETWEEN expression for WHERE clause to select dates within the given range.

1	date_between(column_name, date_range)

`column_name`	[character(1)] Name of data base column to select dates from.
`date_range`	[Date(1:2)] One or two dates giving the date range in which the dates should be enclosed (closed interval). If only one date is given, it is taken for both upper and lower limits.

column_name must be a valid SQL identifier. It is validated to conform to the regular expression returned by valid_identifier_regex.

Character string to be used in SQL statement.

Uwe Block

valid_identifier_regex.

date1 <- as.Date("2016-02-22")
date2 <- as.Date("2016-02-11")

# SQL expression for a date range
(sql_expr1 <- lazysql::date_between("STD_1", c(date1, date2)))

# SQL expression for a single date
(sql_expr2 <- lazysql::date_between("STD_1", date1))

# sample SQL statements
paste("select * from TEST_TABLE where", sql_expr1)

paste("select * from TEST_TABLE where", sql_expr2)