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
What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

What is the way a particular application views the data from the database that the application uses? Sub schema is the way a particular application views the data from the data

What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With

job scheduling for different cubes

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

Question 1 What are the advantages of DBMS approach in managing data? Question 2 What are the services provided by a database system Question 3 List and briefly describe

What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only