Page 1 of 1

Can we insert CURRENT TIMESTAMP using LOAD command

PostPosted: Mon Nov 17, 2008 7:06 pm
by karthickrajamani
HI,

i have a file which has some 10 fields. i need to load these into a table which has 11 fields, the 11th being the timestamp. My requirement is to load the CURRENT TIMESTAMP in the field in the table. Is this possible thru the LOAD utility. I tried giving CURRENT TIMESTAMP as Type for the field and Loading using LOAD command but it says "INVALID KEYWORD - CURRENT". Somebody throw some light on this or suggest a suitable alternative ?

Re: Can we insert CURRENT TIMESTAMP using LOAD command

PostPosted: Tue Nov 18, 2008 12:29 am
by dick scherrer
Hello,

Try CURRENT_TIMESTAMP.