> 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