Data types in sql - timestamp, PL-SQL Programming

Data Types in SQL - Timestamp

TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2012-09-25' (a literal denoting September 25th, 2012). TIME is used for values denoting time of day only, such as TIME '16:30:00' (a literal denoting half-past four in the afternoon).

Posted Date: 1/18/2013 1:58:37 AM | Location : United States







Related Discussions:- Data types in sql - timestamp, Assignment Help, Ask Question on Data types in sql - timestamp, Get Answer, Expert's Help, Data types in sql - timestamp Discussions

Write discussion on Data types in sql - timestamp
Your posts are moderated
Related Questions

Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax: