Results of 1 - 8 of about 8 for Los Angeles (0.004 sec.)
los (8), angeles (8)
- Combining Schemas 27292
- Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When
...er the following two files. flights1.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New York, NY|Los Angeles, CA flights2.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName...1988-01-03|AA|New York, NY|Los Angeles, CA Reading the two files at the same time will produce the following result set: FlightDate UniqueCarrier OriginC...ityName DestCityName 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01-03 AA New York, NY Los Angeles, CA This is equivalent to the SQL co... - https://man.mtool.work/duckdb/2.0/data/multiple_files/combining_schemas.html
- CSV Import 18544
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...le: SELECT * FROM read_csv('flights.csv'); FlightDate UniqueCarrier OriginCityName DestCityName 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01-03 AA New York, NY Los Angeles, CA The path can either be a...FROM 'flights.csv'; SELECT * FROM ontime; flightdate uniquecarrier origincityname destcityname 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01-03 AA New York, NY Los Angeles, CA If we want to manually s... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Reading Multiple Files 17640
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...on_by_name = true, filename = true); FlightDate OriginCityName DestCityName UniqueCarrier filename 1988-01-01 New York, NY Los Angeles, CA NULL flights3.csv 1988-01-02 New York, NY Los Angeles, CA NULL flights3.csv 1988-01-03 New York, NY Los Angele... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- CSV Auto Detection 16990
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...y) Consider the example file flights.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New York, NY|Los Angeles, CA 1988-01-03|AA|New York, NY|Los Angeles, CA In this file, the dialec... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Timestamp Types 16410
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...AMPTZ_NS and retain their full precision. In earlier versions these columns were converted to TIMESTAMP WITH TIME ZONE and lost precision. SELECT TIMESTAMP_NS '1992-09-20 11:30:00.123456789'; 1992-09-20 11:30:00.123456789 SELECT TIMESTAMP '1992-09-2...lendar, but time zones apply locale-specific rules and can vary widely. For example, here is what binning for the 'America/Los_Angeles' time zone looks like near the epoch: The most common temporal binning problem occurs when daylight saving time ch...install and load the icu extension. INSTALL icu; LOAD icu; Next, use the SET TimeZone command: SET TimeZone = 'America/Los_Angeles'; Time binning operations for TIMESTAMPTZ will then be implemented using the given time zone. A list of available time zon... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Timestamp Issues 16194
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...cs almost always uses half-open binning intervals to avoid overlaps at the ends. Unfortunately, the BETWEEN operator is a closed-closed interval: x BETWEEN begin AND end -- expands to begin <= x AND x <= end -- not begin <= x AND x < end To avoid th... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Time Zone Reference List 15724
- An up-to-date version of this list can be pulled from the pg_timezone_names() table function: SELECT name, abbrev FROM pg_timezone_names() ORDER BY name; name abbrev ACT ACT AET AET AGT AGT ART ART AST AST Africa/Abidjan Iceland Africa/Accr
...llo America/Knox_IN America/Knox_IN America/Kralendijk PRT America/La_Paz America/La_Paz America/Lima America/Lima America/Los_Angeles PST America/Louisville America/Louisville America/Lower_Princes PRT America/Maceio America/Maceio America/Managua... - https://man.mtool.work/duckdb/2.0/sql/data_types/timezones.html
- Timestamp with Time Zone Functions 15616
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...e examples below, the current time zone is presumed to be America/Los_Angeles using the Gregorian calendar. Built-In Timestamp with Time Zone Functions The table below shows the available scal...ME ZONE types. Name Description generate_series(timestamptz, timestamptz, interval) Generate a table of timestamps in the closed range (including both the starting timestamp and the ending timestamp), stepping by the interval. range(timestamptz, tim... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work