Timestamp type, Database Management System

Do NOT use the timestamp type.  Use separate date and time data types only.  Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define the date and the time on an insert.  Do not set the MySQL data or time using PHP functions: use only (SQL) MySQL functions embedded in your SQL commands submitted by your script.

Posted Date: 3/29/2013 5:51:17 AM | Location : United States







Related Discussions:- Timestamp type, Assignment Help, Ask Question on Timestamp type, Get Answer, Expert's Help, Timestamp type Discussions

Write discussion on Timestamp type
Your posts are moderated
Related Questions
List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.


Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Data Replication "If a relation R has its copies kept at two or more sites, then it is considered replicated". But why do we replicate a relation? There are several advan

Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e