1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
MakcuM [25]
3 years ago
14

What is DATE data type and its syntax and what is TIMESTAMP data type and its syntax in SQL language.Explain the difference betw

een both of them .
Computers and Technology
1 answer:
qaws [65]3 years ago
5 0

Answer: The DATE datatype give us the particular date whereas TIMESTAMP gives us the date as well as the time as the particular moment.

Explanation:

DATE datatype gives us the date in the format yyyy-mm-dd. The timestamp format is yyyy-mm-dd hh:mm:ss. time stamp are of two types :

timestamp with time zone and timestamp without time zone.

Date is the date on that particular day whereas the timestamp is the date along with the specific time when the query is executed.

You might be interested in
When molten igneous material intrudes into rock _____ metamorphism can occur.
Gnom [1K]
B) Contact metamorphism can occur.
8 0
3 years ago
What is true about content based filtering
AleksAgata [21]

Answer: provide more info

Explanation:

8 0
2 years ago
The IP address and the port are both numbers. Which statement is true?
Tema [17]

Answer:

A computer has one IP address and many ports.

Explanation:

6 0
2 years ago
Marcus creates a HTML webpage on his favourite game, football. On clicking the word “football” another website containing the in
igomit [66]

please mark me as the brainlest answer please

if you do it then I will answer your all questions.

4 0
2 years ago
A blog is best defined as: a web site primarily involved in tracking people's behavior on the Internet. a web site that typicall
Igoryamba

Answer:

a reverse chronological journaling site.

Explanation:

A blog originally known as weblog, is an online journal containing informational or educational content, it usually displays information from the last added item ( that is why it is called reverse chronological journaling site), it can be personal or for a corporate entity for promoting brand identity.

5 0
2 years ago
Other questions:
  • 1. What does it mean to say that a country’s land area is positively correlated with its population?
    12·2 answers
  • This isn't about school but every time it tells me to watch an ad to unlock the answer to a question it prompts a survey and it
    7·2 answers
  • How do you recognize substances that have gone through physical or chemical changes?
    14·2 answers
  • What is Mainframe computer​
    15·1 answer
  • How does the text recommend that a company operate if it wants to be successful in the information age?
    11·1 answer
  • James gets a job at a multinational corporation. On his first day at work, he finds out that the numerical code assigned by the
    6·1 answer
  • A=1/2h(a+b) solve for h
    6·1 answer
  • A security administrator plans to conduct a vulnerability scan on the network to determine if system applications are up to date
    15·1 answer
  • An analogue sensor has a bandwidth which extends from very low frequencies up to a maximum of 14.5 kHz. Using the Sampling Theor
    9·2 answers
  • What is a cookie? *
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!