Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 4 of 4 for DATE_DIFF (0.08 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)
Back to top