Re: help !!! use number or date to store date ????
From: David Roth <droth_at_dr.ultranet.com>
Date: 1995/08/20
Message-ID: <418hq4$6db_at_caesar.ultra.net>#1/1
Date: 1995/08/20
Message-ID: <418hq4$6db_at_caesar.ultra.net>#1/1
sptong_at_singnet.com.sg (Tong Siew Pui) wrote:
>If I want to store the month and year in a table, should I use
> year number(4)
> month number(2)
>or
>should I use date to store the value but default the day to 1st of the
>month ???
>What are the advantages and disadvantages ?????
Oracle stores dates as a number.
There are functions that let yo get at any part of the date that you
need.
There are masks that allow you to convert a date to a character string
in virtually any format.
Received on Sun Aug 20 1995 - 00:00:00 CEST