Top "Truncate" questions

How can I truncate data to fit into a field using SQL*Loader? (ORA-12899)

Using Oracle SQL*Loader, I am trying to load a column that was a variable length string (lob) in another …

substring truncate sql-loader ora-12899

Cut a string after n characters, but if it's in the middle of a word cut the whole word

I'm trying to make a JS function that cuts a string after n characters - that works. The problem is …

javascript jquery character truncate

Oracle PLSQL truncate datetime to specific hours

I have an Oracle PLSQL code generating a list of datetime stamps and I would like to truncate them to …

oracle datetime plsql truncate hour

Is it possible to truncate date to Month with Java 8?

I want to get the milliseconds truncated to days, I can use Instant.now().truncatedTo(ChronoUnit.DAYS).toEpochMilli() But I …

java java-8 truncate java-time

Zebra Programming Language (ZPL) II using ^FB or ^TB truncates text at specific lenghts

I am writing code to print labels for botanic gardens. Each label is printed individually but with different information on …

truncate zpl zpl-ii

Truncate NSDate (Zero-out time)

I want to generate a new NSDate with 0 hours, 0 minutes, and 0 seconds for time. The source date can be any …

objective-c nsdate truncate

execute immediate truncate table in sqlplus

Why does execute immediate 'truncate table trade_economics'; in a sqlplus script give the following error ? BEGIN immediate 'truncate table …

sqlplus truncate execute-immediate

postgres truncate is slow

In postgres 9.2 (CentOS), TRUNCATE TABLE command occasionally took a really long time to run. One time, it took more than 1.5 …

performance postgresql centos truncate

Truncate a string without cut in the middle of a word in rails

How can i truncate a text to the closest position with rails 3 whithout cut in the middle of a word? …

ruby-on-rails ruby-on-rails-3 truncate

sqlite3 is chopping/cutting/truncating my text columns

I have values being cut off and would like to display the full values. Sqlite3 -column -header locations.dbs " select …

sql sqlite truncate