- Sort Score
- Result 10 results
- Languages All
Results 1 - 6 of 6 for dateAdd (0.08 sec)
-
internal/s3select/sql/analysis.go
switch funcName { case sqlFnCast: return e.Cast.Expr.analyze(s) case sqlFnExtract: return e.Extract.From.analyze(s) case sqlFnDateAdd: result.combine(e.DateAdd.Quantity.analyze(s)) result.combine(e.DateAdd.Timestamp.analyze(s)) return result case sqlFnDateDiff: result.combine(e.DateDiff.Timestamp1.analyze(s)) result.combine(e.DateDiff.Timestamp2.analyze(s)) return result
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Sat Dec 23 07:19:11 UTC 2023 - 8.5K bytes - Viewed (0) -
internal/s3select/sql/funceval.go
return aggFnCount case e.Cast != nil: return sqlFnCast case e.Substring != nil: return sqlFnSubstring case e.Extract != nil: return sqlFnExtract case e.Trim != nil: return sqlFnTrim case e.DateAdd != nil: return sqlFnDateAdd case e.DateDiff != nil: return sqlFnDateDiff default: return "" } } // evalSQLFnNode assumes that the FuncExpr is not an aggregation // function.
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Tue Jun 01 21:59:40 UTC 2021 - 13.2K bytes - Viewed (0) -
internal/s3select/sql/timestampfuncs.go
case timePartTimezoneMinute: _, zoneOffset := t.Zone() return FromInt(int64((zoneOffset % 3600) / 60)), nil default: // This does not happen return nil, errNotImplemented } } func dateAdd(timePart string, qty float64, t time.Time) (*Value, error) { var duration time.Duration switch timePart { case timePartYear: return FromTimestamp(t.AddDate(int(qty), 0, 0)), nil case timePartMonth:
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Sun Jan 02 17:15:06 UTC 2022 - 4.8K bytes - Viewed (0) -
internal/s3select/sql/parser.go
TrimChars *PrimaryTerm `parser:" @@? "` TrimFrom *PrimaryTerm `parser:" \"FROM\" )? @@ \")\" "` } // DateAddFunc represents the DATE_ADD function type DateAddFunc struct { DatePart string `parser:" \"DATE_ADD\" \"(\" @( \"YEAR\":Timeword | \"MONTH\":Timeword | \"DAY\":Timeword | \"HOUR\":Timeword | \"MINUTE\":Timeword | \"SECOND\":Timeword ) \",\""` Quantity *Operand `parser:" @@ \",\""`
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Thu Jan 18 07:03:17 UTC 2024 - 12.9K bytes - Viewed (0) -
docs/select/README.md
- Large numbers (outside of the signed 64-bit range) are not yet supported. - The Date [functions](https://docs.aws.amazon.com/AmazonS3/latest/dev/s3-glacier-select-sql-reference-date.html) `DATE_ADD`, `DATE_DIFF`, `EXTRACT` and `UTCNOW` along with type conversion using `CAST` to the `TIMESTAMP` data type are currently supported.
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Thu Sep 29 04:28:45 UTC 2022 - 6.5K bytes - Viewed (0) -
internal/s3select/select_test.go
{"shipdate":"1996-01-29T"} {"shipdate":"1996-04-21T"} {"shipdate":"1996-03-30T"}`, }, { requestXML: []byte(` <?xml version="1.0" encoding="UTF-8"?> <SelectObjectContentRequest> <Expression>SELECT DATE_ADD(day, 2, shipdate) as shipdate FROM S3Object LIMIT 5</Expression> <ExpressionType>SQL</ExpressionType> <InputSerialization> <CompressionType>NONE</CompressionType> <Parquet>
Registered: Sun Nov 03 19:28:11 UTC 2024 - Last Modified: Sat Dec 23 07:19:11 UTC 2023 - 76.2K bytes - Viewed (0)