sql_datetime: SQL Datetime

In poissonconsulting/poiscon: Poisson Consulting Utility Functions

Description

Expands date time column in SQL query to extract Year, Month, ..., Second values.

Usage

sql_datetime(column = "DateTime", suffix = NULL, expand = c("Year",
  "Month", "Day", "Hour", "Minute", "Second"))

Arguments

column	string of column name
suffix	string of suffix to add to expand names
expand	character vector of SQL functions to apply to column and names of columns

Value

A string of the SQL commands

See Also

sql_date and sql_time

Examples

sql_datetime()
sql_datetime(suffix = 'Caught')
sql_datetime('RecaughtD8Time')
sql_datetime('DateTimeRecaught')
sql_datetime('RecaughtDateTime')

poissonconsulting/poiscon documentation built on Feb. 18, 2021, 11:16 p.m.