| Subject | Re: Importing NULL TimeStamp values via External Files |
|---|---|
| Author | robertgilland |
| Post date | 2006-06-30T03:00:27Z |
I have found out how to do this:
by the import procedure doing the below:
CASE WHEN ( RTRIM( DATEFIELD )= '' ) THEN NULL ELSE CAST( DATEFIELD AS
TIMESTAMP ) END AS DATEFIELD
Regards,
Robert
by the import procedure doing the below:
CASE WHEN ( RTRIM( DATEFIELD )= '' ) THEN NULL ELSE CAST( DATEFIELD AS
TIMESTAMP ) END AS DATEFIELD
Regards,
Robert