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
Received on Tue Oct 31 2000 - 14:09:01 CST