SOLVED: Converting string to datetime in SQL Server

[JMvVliet]

I try to do this:

rs.open "INSERT INTO tblY (dt) VALUES(CONVERT(DateTime, '190504072400'))", cn, and so on

However, this won't work. Also trying to insert the same, but then formatted ("19-05-04 07:24:00 ") in the same query won't work. When I use GETDATE() (an sql server function), the date is inserted in the format I've set in red. Why can't I do that manually?

Anyone? Thanx...

[Lightning]

Try this:

rs.open "INSERT INTO tblY (dt) VALUES('2004-05-19 07:24:00'))", cn, and so on

That should work, the conversion is done automatically

[JMvVliet]

That works, thanx