MS SQL and NSTimestamp.DistantFuture
MS SQL and NSTimestamp.DistantFuture
- Subject: MS SQL and NSTimestamp.DistantFuture
- From: David Avendasora <email@hidden>
- Date: Thu, 17 Apr 2008 11:45:49 -0400
Hi all,
Apparently MS SQL Server does not like the value
NSTimestamp.DistantFuture tries to send to the database.
After capturing the exact SQL and trying it out using Aqua Data
Studio, I get the following error: "Syntax error converting datetime
from character string."
The value it is trying to use is: '292278994-08-17 02:12:55'
MS SQL doesn't like anything more than a 4-digit year.
I suppose I could just not use NSTimestamp.DistantFuture, and pass a
date like '9999-12-31 23:59:59' or something. Any better suggestions
for a work-around?
Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden