Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ripperfuel
- Order by date
-
Convert CHARACTER to Date
How about this: select cast(cast('20041101' as date format 'yyyymmdd') as date format 'yyyy-mm-dd'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. '20041101' ---------- 2004-11-01- ripperfuel
- Post #4
- Forum: NCR: Teradata
-
how to insert a text file or a picture in a cloumn
I think, SL23 is asking something like BLOB datatype in Oracle. In Oracle, you can store Excel or Text file (or any type file) in a column that is defined as BLOB. I am also curious to know whether Teradata has a datatype similar to BLOB in Oracle. Thanks.- ripperfuel
- Post #3
- Forum: NCR: Teradata
-
substring function on numeric and charaster values
Case 1: select substring ('12345678', 3, 3); gives 345 as result, which is fine. Case 2: select substring (12345678, 3, 3); gives 12 as result, and select substring(12345678 from 7 for 2); gives 45 as result. I realize I used number in case 2. Can you explain why I am getting '12' and '45' for...- ripperfuel
- Thread
- Replies: 1
- Forum: NCR: Teradata
