Re: Problems with SQL Loader Timestamp

From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 28 Aug 2003 22:11:52 -0700
Message-ID: <febbed51.0308282111.68755fe6@posting.google.com>

LOAD DATA
INFILE 'C:\SQLLOADER\DES_MAST.TXT'
APPEND INTO TABLE DES_MAST
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

(DES_CODE,      
DES_NAME ,     	

DESGRP_CODE,
ENT_DATE DATE(8) "YYYYMMDD",
USER_NAME ,
MODIFY_BY ,
MODIFY_DATE DATE(8) "YYYYMMDD") enter date length (8)
try it Received on Fri Aug 29 2003 - 00:11:52 CDT