title: How to declare a static date when executing a stored proc script?
body: <p>I'm trying to execute a script via Management Studio. </p>
  
  <p>Something like this:</p>
  
  <pre><code>USE [MYDB]
  GO
  
  DECLARE @return_value int
  
  EXEC    @return_value = [dbo].[myTABLE]
          @AsAt = Datetime('27/01/2012 10:37:31'),
          @BatchID = 6754848
  
  SELECT  'Return Value' = @return_value
  
  GO
  </code></pre>
  
  <p>Keep getting errors saying it can't convert from nVarChar to date time. What is the correct way to do this?</p>