HOW TO USE ORACLE TIMESTAMP DATATYPE AND ITS CLASSES

TIMESTAMP IN ORACLE
-------------------------------

CREATE TABLE DEMO
(
ID NUMBER PRIMARY KEY,
TD_I TIMESTAMP,
TD_II INTERVAL YEAR TO MONTH, /*Indicates an Interval of Year to Month : eg. Interval of 2 Years, 3 Months.*/
TD_III INTERVAL DAY TO SECOND, /*Indicates an Interval of Day to Second : eg. Interval of 2 Days,5 Hours, 5 Min and 5 Seconds.*/
TD_IV TIMESTAMP WITH LOCAL TIME ZONE,
TD_V TIMESTAMP WITH TIME ZONE
);

INSERT INTO DEMO(ID,TD_I,TD_II,TD_III,TD_IV,TD_V)
VALUES(1,'01-JAN-2010 12:25 PM','2-3','3 10:10:10','01-AUG-2005 8:00:00 AM','01-AUG-2005 8:00:00 AM +5:30');

select * from demo;

SELECT sysdate,sysdate+TD_II "Future Date",(sysdate+TD_II)-sysdate "Days Difference" FROM DEMO;

Comments

Sample : String Reverse In Java

import java.io.*; class test { public static void main(String args[]) { DataInputStream in=new DataInputStream(System.in); try { String text; System.out.println("\nEnter The Text"); text=in.readLine(); System.out.println("\nIn Reverse Order::\n"); for(int i=text.length()-1;i>=0;i--) { System.out.print(text.charAt(i)); } ...

Getting Browser Information in javaScript

<html> <head> <script> function getBrowserName() { tag_link.innerHTML="You are surfing internet through "+'<b>'+navigator.appName+'</b>'+" browser family." } </script> </head> <body onLoad="getBrowserName()"> <center> <p id="tag_link" style="font-size:30"></p> </center> </body> </html>

How to use DDL or DML within PL/SQL Block

SET SERVEROUTPUT ON DECLARE TBSTMT VARCHAR2(2000):='CREATE TABLE DEMO (ID NUMBER,MSG VARCHAR2(20))'; BEGIN EXECUTE IMMEDIATE TBSTMT; END;

wideIT

Search This Blog