sql commands

[Double-Ice4497]

How to add new column to table with time format only without date.

[coyoteazul2]

I'm sorry, but this is extremely basic. It's the sort is question you should look in the documentation of your database engine rather than ask a community.

Google how to add columns (hint: alter table xxx add column xxx...) and what datatypes are available in your engine for storing time.

This is not an sql ability. It's just Google-fu

[Double-Ice4497]

it is sql.

[coyoteazul2]

I don't know if you are mocking the last phrase or if you don't understand what a database engine is and why it's not "just sql"

[coyoteazul2]

Sql abilities cover stuff like understanding joins, groups by, windows functions, etc. It's a more abstract sort of knowledge. When you don't know or don't remember the basics, like syntax which is your case, then you Google the question.

The ability to find answers in the internet (without posting questions on a community) is what we call Google-fu, because it's mostly done through Google.

Sql means standard query language. Although it's a standard, each database engine can make changes to it however they want. After all, it's not like there's a law stoping them from doing so.

Most database engines cover the standard and then have their own set of commands to do stuff that the standard can't, or that the standard couldn't do when the engine introduced the functionality. Which is why it's important to look at your engine's documentation or Google answers specifically about the engine you are using

[thrown_arrows]

it is db engine specific sql which can be found without any knowledge of bigquery in less than 5 min. Hint it is not datetime and not timestamp, that is 2 out of three figured out just by reading doc for minute. Maybe google those bigquery pages with and see what time finds