Since date is stored as century, year, month, day, hour, minute, second,
you can also zap the last three bytes.
----- Original Message -----
From: <Yosi_at_comhill.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, October 31, 2000 2:39 PM
Subject: RE: how to define date column in a table with only mm/dd/yyyy por
> David's probably rigfht, but if you still want to eliminate it, trigger the
> table on update and insert to set the value of new.trade_date to
> trunc(new.trade_date).
>
> HTH,
>
> Yosi
>
>
> > -----Original Message-----
> > From: David Barbour [mailto:DBarbour_at_connectsouth.com]
> > Sent: Tuesday, October 31, 2000 2:46 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: how to define date column in a table with only mm/dd/yyyy
> > por
> >
> >
> > Rao,
> >
> > Stop for a minute and think about your question. Just
> > timestamp the column
> > using SYSDATE. It doesn't matter what the format is IN the
> > table, it's all
> > about how you format it when you get it OUT of the table.
> >
> > David A. Barbour
> > Oracle DBA - ConnectSouth
> > 512-681-9438
> > dbarbour_at_connectsouth.com
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, October 31, 2000 11:32 AM
> > To: Multiple recipients of list ORACLE-L
> > portion
> >
> >
> > Hi All,
> >
> > I have table that contains a column - TRADE_DATE.
> >
> > This column should always contain only the date portion -
> > mm/dd/yyyy. It
> > SHOULD NOT contain time portion.
> >
> > Is there any way, I can define this column or can I use some kind of
> > constraint clauses on this column? If yes, please tell me how
> > to do this.
> >
> > TIA,
> >
> > Rao
> >
> >
> > Maheswara.Rao_at_SunGardP3.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rao, Maheswara
> > INET: Maheswara.Rao_at_Sungardp3.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David Barbour
> > INET: DBarbour_at_connectsouth.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Yosi_at_comhill.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Oct 31 2000 - 15:05:30 CST
