Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 7 of 7 for date_diff (0.11 sec)

  1. internal/s3select/sql/parser.go

    	Quantity  *Operand     `parser:" @@ \",\""`
    	Timestamp *PrimaryTerm `parser:" @@ \")\""`
    }
    
    // DateDiffFunc represents the DATE_DIFF function
    type DateDiffFunc struct {
    	DatePart   string       `parser:" \"DATE_DIFF\" \"(\" @( \"YEAR\":Timeword | \"MONTH\":Timeword | \"DAY\":Timeword | \"HOUR\":Timeword | \"MINUTE\":Timeword | \"SECOND\":Timeword ) \",\" "`
    	Timestamp1 *PrimaryTerm `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)
  2. internal/s3select/select_test.go

    			query:      `SELECT date_diff(year, '2010-01-01T', '2011-01-01T') FROM S3Object LIMIT 1`,
    			wantResult: `{"_1":1}`,
    		},
    		{
    			name:       "date_diff_year",
    			query:      `SELECT date_diff(month, '2010-01-01T', '2010-05T') FROM S3Object LIMIT 1`,
    			wantResult: `{"_1":4}`,
    		},
    		{
    			name:       "date_diff_month_oney",
    			query:      `SELECT date_diff(month, '2010T', '2011T') FROM S3Object LIMIT 1`,
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Sat Dec 23 07:19:11 UTC 2023
    - 76.2K bytes
    - Viewed (0)
  3. 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)
  4. internal/s3select/sql/funceval.go

    	sqlFnCoalesce FuncName = "COALESCE"
    	sqlFnNullIf   FuncName = "NULLIF"
    
    	// Conversion
    	sqlFnCast FuncName = "CAST"
    
    	// Date and time
    	sqlFnDateAdd     FuncName = "DATE_ADD"
    	sqlFnDateDiff    FuncName = "DATE_DIFF"
    	sqlFnExtract     FuncName = "EXTRACT"
    	sqlFnToString    FuncName = "TO_STRING"
    	sqlFnToTimestamp FuncName = "TO_TIMESTAMP"
    	sqlFnUTCNow      FuncName = "UTCNOW"
    
    	// String
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Tue Jun 01 21:59:40 UTC 2021
    - 13.2K bytes
    - Viewed (0)
  5. internal/s3select/sql/timestampfuncs.go

    }
    
    // dateDiff computes the difference between two times in terms of the
    // `timePart` which can be years, months, days, hours, minutes or
    // seconds. For difference in years, months or days, the time part,
    // including timezone is ignored.
    func dateDiff(timePart string, ts1, ts2 time.Time) (*Value, error) {
    	if ts2.Before(ts1) {
    		v, err := dateDiff(timePart, ts2, ts1)
    		if err == nil {
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Sun Jan 02 17:15:06 UTC 2022
    - 4.8K bytes
    - Viewed (0)
  6. internal/s3select/sql/analysis.go

    	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
    
    	// Handle aggregation function calls
    	case aggFnAvg, aggFnMax, aggFnMin, aggFnSum, aggFnCount:
    		// Initialize accumulator
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Sat Dec 23 07:19:11 UTC 2023
    - 8.5K bytes
    - Viewed (0)
  7. bin/diff_yaml.py

    # limitations under the License.
    #
    # Compare 2 multi document kubernetes yaml files
    # It ensures that order does not matter
    #
    from __future__ import print_function
    import argparse
    import datadiff
    import sys
    import yaml  # pyyaml
    
    # returns fully qualified resource name of the k8s resource
    
    
    def by_resource_name(res):
        if res is None:
            return ""
    
    Registered: Wed Nov 06 22:53:10 UTC 2024
    - Last Modified: Wed Mar 03 16:14:57 UTC 2021
    - 4.5K bytes
    - Viewed (0)
Back to top