Oracle-L: Date fields store as varchar2???

From: Celine John <celine_mj_at_yahoo.com>
Date: Fri, 19 Apr 2002 11:28:21 -0800
Message-ID: <F001.00449C14.20020419112821@fatcity.com>

Hello,

Our DB has a GMT time zone, while our data warehouse has EST.

For our application, some guys here insist that we store dates as varchar2 to avoid all the problems associated with data in the two databases.

Though personally I want the dates to be stored in oracle date datatype, I would like to know more about how date fields behave in different processes... like
1) Snapshots - if the date in the data WH is going to be refreshed via a snapshot, what will the value be. 2) Export/Import
3) SQLLoader

I depend on this list to give me some expert advice on this.

Thanks much.

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Celine John
INET: celine_mj_at_yahoo.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). Received on Fri Apr 19 2002 - 14:28:21 CDT