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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
