BDE, MSSQL6.5 & DateTime type (BDE Setup???)

What is the correct configuration of BDE (and MSSQL Server) that allows to
read/modify fields of MSSQL DateTime type ?
I use BDE/Delphi4, Date format is DDMMYY... and have no idea how to avoid annoying 'SQL: cannot convert datetime from string'.
Who is Participating?
chigrikConnect With a Mentor Commented:
Uncheck "Use international settings" in SQL Client Configuration Utility.
It must work.
Gustavo Perez BuenrostroCommented:
Why don't you use ISO Standard date format from Delphi?

ISO Date Standard:yyyymmdd
martinplAuthor Commented:
I have to use my national date standard
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Gustavo Perez BuenrostroCommented:
Try setting Date format from Delphi.
Consult DATEFORMAT statement in BOL.
Gustavo Perez BuenrostroCommented:
Gustavo Perez BuenrostroCommented:

Was chigrik's answer the correct answer?

Why don't you post a comment related to?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.