Convert a Integer into Date

[shaan1980]

I want to select a column which is in the following integer format yyyymmdd into the following date format mm/dd/yyyy

I tried the convert function but that yeilded an error

Can you please advise how I could do this

[txbakers]

what language are you using and what database are you using.

You might be able to use some type of DATE_FORMAT command in the SQL to get it that way.

OR you can do the coding in your language. I've done it both ways.

[shaan1980]

i'm using SQL on Sybase