Converting dates in SQLServer and Access

Question

Is there a function that works in both MS Access and SQLServer 2k5 + that converts a string to a date? CDate seems to work in access, and Convert works in SQLServer, but I need a function that works in both.

Thanks!

Answer 1

It is important to remember that SQL and Access do not work on the same platform, and you will not have access to the same functions on each platform. This is similar to asking if you can use the echo command in ASP.NET. Echo works in PHP, but not in .NET. I do not believe that you will find a common function that you can use.

, .

SQL...

cast (MyColumn as datetime)

...

cdate(MyColumn)

:

• MSDN: SQL
• : CDATE

Answer 2

MS Access Sql Server . , , .