文件名称：Functions-for-Manipulating-Data-in-PostgreSQL-Datacamp
文件大小：13KB
文件格式：ZIP
更新时间：2024-04-06 16:11:49
Functions-for-Manipulating-Data-in-PostgreSQL-Datacamp
【文件预览】：
Functions-for-Manipulating-Data-in-PostgreSQL-Datacamp-main
----3.Parsing and Manipulating Text()
--------Replacing string data.sql(117B)
--------Changing the case of string data.sql(409B)
--------Combining functions for string manipulation.sql(255B)
--------The TRIM function.sql(373B)
--------Truncating strings.sql(117B)
--------Determining the length of strings.sql(175B)
--------Concatenating strings.sql(497B)
--------Extracting substrings from text data.sql(154B)
----1.Overview of Common Data Types()
--------Searching an ARRAY with ANY.sql(136B)
--------Determining data types.sql(211B)
--------Accessing data in an ARRAY.sql(517B)
--------Getting information about your database.sql(507B)
--------Searching an ARRAY with @>.sql(159B)
--------Interval data types.sql(185B)
----2.Working with DATE | TIME Functions and Operators()
--------Using DATE_TRUNC.sql(723B)
--------Adding and subtracting date and time values.sql(700B)
--------Putting it all together.sql(2KB)
--------INTERVAL arithmetic.sql(441B)
--------Calculating the expected return date.sql(357B)
--------Manipulating the current date and time.sql(623B)
--------Working with the current date and time.sql(608B)
--------Using EXTRACT.sql(417B)