Page 1 of 1
Problem of insert a datetime value from Delphi application
Posted: Mon 21 Mar 2005 12:09
by foalex
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.
Datetime value
Posted: 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'
Re: Problem of insert a datetime value from Delphi application
Posted: Tue 22 Mar 2005 09:03
by Ikar
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.
Re: Datetime value
Posted: Tue 22 Mar 2005 11:51
by Ikar
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'