Quick data conversion question using CAST? 1

[octavian10]

SELECT ID, ACTIVATE, DEACTIVATE,
CAST(ACTIVATE AS VARCHAR) AS [Activate Date],
CAST(DEACTIVATE AS VARCHAR) AS [Deactivate Date]
FROM VENDOR

In the above statement how do you keep the original ACTIVATE and DEACTIVATE from being returned in the result set? In other words, I only want to see the converted date in the query result.

ACTIVATE and DEACTIVATE are smalldatetime

Thanks in advance for anyone's time

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)

 

[mrdenny]

Remote the raw values from the SELECT statement and they will no longer be included. The original values are not required to be shown.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[octavian10]

Cool, thanks again.

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)

 

[mrdenny]

np

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog