SQL Server Datetime
- How-to
- SQL Server
- Andrew Davis
- PowerBuilder
- Monday, 8 April 2024 11:25 AM UTC
Hi
pb 2022r3 win10 sql 15
All, still trying to connect to a sql server rather than my normal SQL Anywhere.
I am trying to save a PB datetime field back to the SQL server database and I am getting an error
SQLSTATE = 22007
Microsoft SQL Server Native Client 11.0
Conversion failed when converting date and/or time from character string.
No changes made to database.
INSERT INTO "rfid_import_stats" ( "run_id", "last_run_time", "newest_data", "records_changed" ) VALUES ( 2, '2024-02-28 14:49:07.978783', '1900-01-01 00:00:00.000', 0 )
Any help would be greatly appreciated - the field in the SQL is type datetime - should i use a different type ?
regards
Andew
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.