Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 6 of 6 for dateAdd (0.08 sec)

  1. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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)
Back to top