As a long time user of Oracle and a new user of Sql Server - my opinion depends on my last task. I have days that I marvel at SqlServer's...

Thanks! This worked.

SELECT DATEADD(s, open_date, '1 / 1 / 1970') AS conv_dt FROM table_name

Much appreciated

THANKS!!!!

SELECT DATEADD(s, open_date, '1 / 1 / 1970') AS conv_dt FROM table_name

Thanks so much for your reply. I'm new to SQLSERVER so bare with me. I'm selecting a field from a table (opendate)that is a character field in time_t. If I...