Re: Dates in SQL?

From: Donna Kray <donna.kray_at_gemis.ge.com>
Date: 1996/10/16
Message-ID: <542kvr$16n_at_crissy.ge.com>#1/1

rkwan_at_unixg.ubc.ca (Raymond Wan) wrote: ..>
>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 **
>** ------------------------------------------------ **
>
>

---

Look up the TO_DATE and TO_CHAR functions in your SQL reference book(s). You can use about any format for the date & time that you want.

DL Kray Received on Wed Oct 16 1996 - 00:00:00 CEST