convert datetime from varchar error

Use the third parameter to CONVERT, the style parameter.

For your particular style, you want to use style 103:

SELECT CONVERT(datetime,'22/09/2009 13:15:13', 103);

For more information, see the reference here: http://msdn.microsoft.com/en-us/library/ms187928.aspx

A good practice is always to use the ISO format of 'yyyymmdd' when using text dates, as that can't be mis-interpreted, and also sorts naturally in date order when using a text sort.

Try this

set dateformat dmy
select CONVERT(datetime,'22/09/2009 13:15:13')

Hope this will help

Its because the value is being read in the format mm/dd/yyyy and there isnt a 22nd month. If you change the format of the supplied date it should be fine

convert(datetime, '20090922 13:15:13') --uses the ISO standard format of yyyymmdd

convert(datetime, '2009-Sep-22 13:15:13') --uses the the month name to avoid confusion but may have mixed results if you have any access that uses a non english month name
convert(datetime, '09/22/2009 13:15:13') -- uses the format expected by your installation

hope this helps