i am also encountering this problem..
mine is page iteration..
so wats "You should increase the heap size value in the MM eway's configuration file." --->MM???
thnks in Advanced..
i m writing a store procedure..
anyway.. the solution which i found out is--
declare @ldate varchar(20)
set @ldate = convert(char,getdate(),103)
will let @ldate to be in ddmmyyy format w/o the time ..
i tried.. to convert the format to ddmmyyyy format..
by:
declare @ldate datetime
set @ldate = convert(datetime, getdate(),103)
but it appear as result below..
2003-06-13 14:39:43.107
hw can i convert to 13/06/2003 without the time
thanks in advance...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.