General information
Title:
VFP & SQL Server: Dates
Hi all,
The question i have is:
When i'm creating a string to use at a SQLEXEC(), i'm having a problem with dates, because SQL Server receives it from another format. Imagine this code:
lcInstruction = "Update clients set date_payment = '" + ttoc(ldDatePay) + "' where codCli = ....."
When i do a SELECT instruction from my table, i see that the date value is 2000-08-09, but the value of my update is wrong. And, to help wprst a little bit, TTOC() function doesn't give a dam with the SET DATE ...
I know i could solve it with a remote view, but i don't want! I just want to make an update operation.
Is there a way to get the date format from the SQL S.(and i could prepare the right instruction)?
Any ideas?
Thanks,
Ricardo
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only