What is the Difference Between Since and From?

The main difference between "since" and "from" lies in the continuation of the action. Here are the key distinctions:

• Since: This word is used when an action started in the past and continues up to the present. It indicates a specific point in time when an event began or an action started. For example: "I have been working here since 2015."
• From: This word is used to denote the start of a time period or a spatial range, and does not necessarily imply that the action or event is still ongoing. For example: "I will be on vacation from next Monday."

In summary:

• "Since" is used for actions or events that started in the past and are still ongoing.
• "From" is used for actions or events that started in the past and may or may not be ongoing, as well as for marking the start of a time period or a spatial distance.

Comparative Table: Since vs From

The search results provided do not directly address the difference between "since" and "from" in the context of creating a table. However, I can provide you with a general understanding of the two terms:

• From: "From" is used in various SQL operations to specify the source of data, such as in the SELECT statement where you extract data from an existing table using the FROM keyword. "From" is also used in CREATE TABLE statements when you want to copy data from one table to another or when specifying the source of data in an outer join operation using syntax like FROM table1, table2.

• Since: "Since" is not commonly used in SQL operations for creating tables. However, it can be used in contexts like CREATE TABLE ... CLONE or CREATE TABLE ... EXTERNAL to specify a specific time or timestamp when the data should be cloned or retrieved, respectively. For example, in Snowflake's CREATE TABLE ... CLONE statement, you can use the SINCE clause to specify the timestamp until which the clone should be created.

In summary:

Please note that these definitions are based on general SQL knowledge and may vary depending on the specific database system being used.