Problem of insert a datetime value from Delphi application

foalex · Post by **foalex** » Mon 21 Mar 2005 12:09

I'm with a problem for post a datetime value in my sqlserver database, because the field in a database is a datetime, and in my application too. But in the insert have a error, because the dbexpress don't accept the datetime value with delphi convertion.
Thank's for the help.
Best regards.

[email protected] · Post by **[email protected]** » Mon 21 Mar 2005 14:02

I found the same problem .....
There I found two ways to resolve it:
1. Change date format for SQL Server
2. Passing DateValue to server as Quoted string in format yyyyMMdd
f.e. '19581207'

Ikar · Post by **Ikar** » Tue 22 Mar 2005 09:03

foalex wrote:I'm with a problem for post a datetime value in my sqlserver database, because the field in a database is a datetime, and in my application too. But in the insert have a error, because the dbexpress don't accept the datetime value with delphi convertion.
Thank's for the help.
Best regards.

We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.

Ikar · Post by **Ikar** » Tue 22 Mar 2005 11:51

Do you use DbxSda or SDAC?

[email protected] wrote:I found the same problem .....
There I found two ways to resolve it:
1. Change date format for SQL Server
2. Passing DateValue to server as Quoted string in format yyyyMMdd
f.e. '19581207'

Devart Forums

Problem of insert a datetime value from Delphi application

Problem of insert a datetime value from Delphi application

Datetime value

Re: Problem of insert a datetime value from Delphi application

Re: Datetime value