[thelist] SQL Problem

rudy r937 at interlog.com
Mon May 7 08:02:53 CDT 2001


> Which language supports the convert function?

hi marios

sql/server supports convert

in fact, the weird conversion i gave you, for the date format, is uniquely
sql/server

    convert(char(10),timestamp,102)

see  http://msdn.microsoft.com/library/psdk/sql/ts_ca-co_2f3o.htm


> I am asking this because i'm getting the following error:
>   Syntax error converting DATETIME from character string.

try defining your view in query manager, and if it fails there, show me
your create view statement again



rudy






More information about the thelist mailing list