> 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