Hi Danny,
Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote:
>
> Ok,
>
> DATE 'DD.MM.YYYY'
>
> workes fine, but how to make it with timestamp values ?
>
> I have a command file :
>
> Create table datetest (
> nr smallint,
> name char(50),
> heute date
> )
> //
> DATALOAD table datetest
> nr 1
> name 2
> heute 3
> INFILE '/home/sapdb/datetest.inp'
> DATE 'YYYY-MM-DD-HH.MM.SS.MMMMMM'
> SEPARATOR ','
> DELIMITER ''
>
> and the input file :
>
> 1,Holger,1999-01-23-14.30.08.456234
> 2,Achim,2003-02-19-10.06.50.123456
>
>
> But here comes the Errormessage :
>
> Error during execution
> -->-25301
> Invalid input for date or time column: 1999-01-23-14.30.08.456234
>
> Defined maximum number of errors (1) reached
>
>
> maybe I have to take an other Statement instead of 'DATE', or an other
> column datatype ?
>
Yes, TIMESTAMP as stated in the docs. Replace DATE with TIMESTAMP in your
command.
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
