I have a standard stored procedure that contains the following code:
SET @.SQL = 'SELECT id, building, firstname, lastname, closed, assignto, vandalism, entered_by, phone, roomno, status, dateentered, date_closed AS DATECLOSED FROM requests '
SET @.SQL = @.SQL + 'WHERE building_no IN (' + @.BUILDINGLIST + ') AND STATUS_NO = ' + @.STATUS + ' '
Works fine, but my dates come back unformated i want to replace the above:
dateentered and date_closed
with
CONVERT(varchar(30), dateentered, 101) AS DATEENTERED
CONVERT(varchar(30), date_closed, 101) AS DATECLOSED
but, when i do, i receive the following error:
ERROR CLOSE TO AS
Does anyone have any ideas? Thanks in advance.
Richard M.what's it look like when you've already replaced them?
CONVERT(varchar(30), dateentered, 101) AS DATEENTERED
also, dateentered appears to be a field that doesn't exist.
No comments:
Post a Comment