Dates in SQL?

From: Raymond Wan <rkwan_at_unixg.ubc.ca>
Date: 1996/10/14
Message-ID: <53sfsk$d1f_at_nntp.ucs.ubc.ca>#1/1

        Hi, all! Sorta basic question compared to what's in this newsgroup...but oh well! At least there's a good chance someone can help me! ^_^

        Does anyone know how to use [insert and select] dates in Oracle v7.x SQL [in SQL*Plus and Pro*C]? I've gotten as far as creating the table:

CREATE TABLE TEMP (

	tempdate DATE not null,
	...);

	But I don't really know how to insert a date into it or select a 

date from it in both SQL*PLUS and PRO*C. I also understand that the DATE datatype also stores the time... *shrug*

        Thanks!

Raymond Wan

• ------------------------------------------------ **
• Raymond Wan **
• Department of Computer Science, **
• University of British Columbia **
• e-mail: rkwan_at_unixg.ubc.ca **
• WWW: http://www.ugrad.cs.ubc.ca/spider/h0h1 **
• ------------------------------------------------ **

Received on Mon Oct 14 1996 - 00:00:00 CEST