passing a smalldate time variable in sql?

Question

There is an sp,

EXEC Dbo.CREATE_A_PEACEFULL_WORL 'A',2,??

?? presents a smalldatetime variable, the date is must be like; 24.02.2010 00:00:00

how can i pass it?

Answer 1

Try this:

EXEC Dbo.CREATE_A_PEACEFULL_WORL 'A',2
    ,SELECT CONVERT(varchar(10),@yourSmallDate,104)
    +' '+CONVERT(varchar(8),@yourSmallDate,108)