0 - 6 of 6 tags for casting

Hi All,
 
I have data like these . 

Mar 22, 2016 12:06:35 PM

Hi 
Please advise in Teradata how to convert integer value to binary and then back to integer ? If there is any function for that ?
For example: integer value is 50, binary will be 00110010 and again from 00110010 back to 50.
 
Thanking You
Santanu Ghosh

I'm running a query in Tera mode. 
My query looks something like:

select *

from dwh.tablename

where SHA256('ph5p6uTezuwr4c8aprux' || stringfield ) = '480b1ec07f9e5d2ca3e63e9f5278608ffb4b2e311b26e6970f47f9149dbc3735'

 

hi I have a  TABLE1  with this structure 

CREATE  MULTISET TABLE DB1 .TABLE1 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      

     

   

      PRODUCT_NBR INTEGER

)

 

Hi.
I've created a very small table to illustrate the issue, I'ld like to hear opinions about.
CREATE MULTISET TABLE Table_1
,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
Textfield CHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC
)

Hi All,
I am trying to cast a column into decimal but its failing with the error