hsSqlExTsFields: SQL Expression: Timestamp Info

In KWB-R/kwb.db: Functions supporting data base access

SQL Expression: Timestamp Info

Description

Generates SQL code for selecting different parts of the timestamp

Usage

hsSqlExTsFields(tsField, extraTsFields = 0:11)

Arguments

tsField

name of the table field containing the timestamp

extraTsFields

vector of integers representing different types of time-stamp information: 0 = the timestamp in POSIXct as it is converted to by R from the text representation delivered by MS Access, 1 = Timestamp as character string, 2 = Date, 3 = number of days since 1899-12-30, 4 = number of seconds since midnight of Date 5 = number of minutes since midnight of Date 6:8 = year, month, day 9:11 = hours, minutes, seconds

Value

Returns SQL code for selecting different types of information on the time stamp.

See Also

hsGetTimeSeries

Examples

hsSqlExTsFields("myTimestamp", c(6:11))
  
## Output (re-formatted):
# "Year(myTimestamp) AS myTimestamp_year, 
#   Month(myTimestamp) AS myTimestamp_month, 
#   Day(myTimestamp) AS myTimestamp_day, 
#   Hour(myTimestamp) AS myTimestamp_h, 
#   Minute(myTimestamp) AS myTimestamp_m, 
#   Second(myTimestamp) AS myTimestamp_s"

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.