SELECT cast ((545458874489 (format ’999-999-9999′)) as char (15)) as Format_Cast_PhoneNum
Output would be something like follows;
Format_Cast_PhoneNum
***********
This happens because of the number of digits presented (12 in this case) to the format function is more than the number of symbol digits (10 in this case) or format characters available in the format command.
Again,Number of digits presented is 12 è 545458874489
Number of Symbolic character is 10 è 999-999-9999 (excluding the dash character)
Hence, you get error in your output.
How to solve this? Just make sure that the number of Symbolic character/digit is always equal or greater than the number of digits presented for formatting/conversion. The above SQL can be written in as follows to get a correct result.
SELECT cast ((545458874489 (format ‘99-999-999-9999′)) as char (15)) as Format_Cast_PhoneNum
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links
4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.