07 July 2009

Teradata: Ceil() equivalent function

Ceil() เป็น function บน Oracle ใช้สำหรับปัดตัวเลขขึ้นเสมอ แต่บน TD ไม่มีคำสั่งนี้
บน TD ในกรณีที่ต้องการปัดเลขทศนิยมขึ้นเป็น Integer เสมอ ใช้คำสั่ง
SELECT cast((col1) as int) + (case when (col1) mod 1 > 0 then 1 else 0 end);

2 comments:

Aura Romano said...

Some of the features of online slots are extremely sizeable bonus deals and unique awards that athletes will receive having an Asiancasinoclub you may play anytime and anywhere you desire, you can play for many hours while both at home and play for a couple of-3 a few minutes on your break. You also can register rapidly and safely and securely

Tammy Hart said...

The team delivered on time and within budget, and proposed functionality changes to give the app better functionality. award winning web development company