Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Could not parse SQL TimeStamp string


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0
Barry Wood

Posts: 21
Registered: 7/16/01
Could not parse SQL TimeStamp string  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 1, 2015 1:53 AM
Hi

I have a TFDQuery set up using a Parameter to extract data. The data is held in MS SQL Server 2008 and the field is a MS SQL DateTime field. The Parameter data type I've set as both ftDateTime and ftSQLTimeStamp (either extracts the data in the FireDAC Query Editor). When I run the application I get this error: 'Could not parse SQL TimeStamp string'. I get this error every time the query is run.

What is also odd is that the query actually runs OK and I get the result set I need, so whatever the error is telling me isn't affecting the result, other than the annoying error message.

I'm loath to just trap this error and ignore it but I can't figure out how I can 'fix' the issue. This whole datetime issue with MS SQL Server is really annoying, I'm nearly at the point of never using these types of fields as they always throw up conversion errors.

Any suggestions would be of great help.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02