Results of 1 - 10 of about 25 for month (0.004 sec.)
- UNPIVOT Statement – DuckDB 13649
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s) LIMIT number_of_rows ; Example Data All examples use the dataset produced by the queries below: CREATE OR REPLACE TABLE monthly_sales ( empid INTEGER , dept TEXT , Jan INTEGER , Feb INTEGER , Mar INTEGER , Apr INTEGER , May INTEGER , Jun INTEGER );...INSERT INTO monthly_sales VALUES ( 1 , 'electronics' , 1 , 2 , 3 , 4 , 5 , 6 ), ( 2 , 'clothes' , 10 , 20 , 30 , 40 , 50 , 60 ), ( 3 , 'cars...' , 100 , 200 , 300 , 400 , 500 , 600 ); FROM monthly_sales ; empid dept Jan Feb Mar Apr May Jun 1 electronics 1 2 3 4 5 6 2 clothes 10 20 30 40 50 60 3 cars 100 200 300 400... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- Hive Partitioning – DuckDB 11291
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...g = true ); Write a table to a Hive partitioned data set: COPY orders TO 'orders' ( FORMAT parquet , PARTITION_BY ( year , month )); Note that the PARTITION_BY options cannot use expressions. You can produce columns on the fly using the following synt...ax: COPY ( SELECT * , year ( timestamp ) AS year , month ( timestamp ) AS month FROM services ) TO 'test' ( PARTITION_BY ( year , month )); When reading, the partition columns are..._partitioning parameter. FROM read_parquet ( 'test/*/*/*.parquet' , hive_partitioning = false ); -- will not include year, month columns FROM read_parquet ( 'test/*/*/*.parquet' , hive_partitioning = true ); -- will include year, month partition colum... - https://man.mtool.work/duckdb/1.3/data/partitioning/hive_partitioning.html
- Date Functions – DuckDB 10444
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...false otherwise. julian(date) Extract the Julian Day number from a date. last_day(date) The last day of the corresponding month in the date. least(date, date) The earlier of two dates. make_date(year, month, day) The date for the given parts. monthna...me(date) The (English) name of the month. strftime(date, format) Converts a date to a string according to the format string . time_bucket(bucket_width, date[, offs...cate date to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, date[, origin]... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Partitioned Writes – DuckDB 10228
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...a table to a Hive partitioned data set of Parquet files: COPY orders TO 'orders' ( FORMAT parquet , PARTITION_BY ( year , month )); Write a table to a Hive partitioned data set of CSV files, allowing overwrites: COPY orders TO 'orders' ( FORMAT csv ,...PARTITION_BY ( year , month ), OVERWRITE_OR_IGNORE ); Write a table to a Hive partitioned data set of GZIP-compressed CSV files, setting explicit data...files' extension: COPY orders TO 'orders' ( FORMAT csv , PARTITION_BY ( year , month ), COMPRESSION gzip , FILE_EXTENSION 'csv.gz' ); Partitioned Writes When the PARTITION_BY clause is specified for the COPY... - https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html
- Interval Type – DuckDB 10012
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ription INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units. Units that aren't months , days , or microseconds are converted to equivalent amounts in the next smaller of these three basis units. SELECT INTER...VAL 1 YEAR , -- single unit using YEAR keyword; stored as 12 months INTERVAL ( random () * 10 ) YEAR , -- parentheses necessary for variable amounts; -- stored as integer number of months I...NTERVAL '1 month 1 day' , -- string type necessary for multiple units; stored as (1 month, 1 day) '16 months' :: INTERVAL , -- string cast... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Date Format Functions – DuckDB 9265
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...x ; Invalid Input Error: Could not parse string "02/50/1992" according to format specifier "%d/%m/%Y" 02/50/1992 ^ Error: Month out of range, expected a value between 1 and 12 To return NULL on failure, use the try_strptime function : NULL CSV Parsin...cifier Description Example %a Abbreviated weekday name. Sun, Mon, … %A Full weekday name. Sunday, Monday, … %b Abbreviated month name. Jan, Feb, …, Dec %B Full month name. January, February, … %c ISO date and time representation 1992-03-02 10:30:20 %d...Day of the month as a zero-padded decimal. 01, 02, …, 31 %-d Day of the month as a decimal number. 1, 2, …, 30 %f Microsecond as a decimal... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- Timestamp Functions – DuckDB 8784
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...false otherwise. julian(timestamp) Extract the Julian Day number from a timestamp. last_day(timestamp) The last day of the month. least(timestamp, timestamp) The earlier of two timestamps. make_timestamp(bigint, bigint, bigint, bigint, bigint, double)...econds since the epoch to a timestamp. make_timestamp_ns(nanoseconds) Converts nanoseconds since the epoch to a timestamp. monthname(timestamp) The (English) name of the month. strftime(timestamp, format) Converts timestamp to string according to the...to a grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, times... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Date Part Functions – DuckDB 8634
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Specifier Description Synonyms Example century Gregorian century cent , centuries , c 21 day Gregorian day days , d , dayofmonth 3 decade Gregorian decade dec , decades , decs 202 hour Hours hr , hours , hrs , h 11 microseconds Sub-minute microseconds...-minute milliseconds millisecond , ms , msec , msecs , msecond , mseconds 44123 minute Minutes min , minutes , mins , m 59 month Gregorian month mon , months , mons 8 quarter Quarter of the year (1-4) quarters 3 second Seconds sec , seconds , secs , s...e are dedicated extraction functions to get certain subfields: Name Description century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturday = 6). dayofyear(date) Day of the year (starts f... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- Pivot Internals – DuckDB 8302
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s. If dynamically unpivoting, the COLUMNS expression is evaluated first to calculate the column list. For example: UNPIVOT monthly_sales ON jan , feb , mar , apr , may , jun INTO NAME month VALUE sales ; is translated into: SELECT empid , dept , unnes...t ([ 'jan' , 'feb' , 'mar' , 'apr' , 'may' , 'jun' ]) AS month , unnest ([ "jan" , "feb" , "mar" , "apr" , "may" , "jun" ]) AS sales FROM monthly_sales ; Note the single quotes to build...a list of text strings to populate month , and the double quotes to pull the column values for use in sales . This produces the same result as the initial example:... - https://man.mtool.work/duckdb/1.3/internals/pivot.html
- Timestamp with Time Zone Functions – DuckDB 7987
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
.... extract(field FROM timestamptz) Get subfield from a TIMESTAMP WITH TIME ZONE . last_day(timestamptz) The last day of the month. make_timestamptz(bigint, bigint, bigint, bigint, bigint, double, string) The TIMESTAMP WITH TIME ZONE for the given parts...grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00+00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width,...The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestampt... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
DuckDB 1.3 Documentation / man.mtool.work