revvinghigh
Programmer
need help on how to keep milliseconds from SQL into VFP when using sql pass through?
thanks in advance.
thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
keeping milliseconds from SQL
- Thread starter revvinghigh
- Start date
- Status
I don't believe you can - the DateTime field that VFP uses doesn't support more reolution than seconds. Now if you want to cast the milliseconds to a separate int or char field in the SP or SPT, then you could save them off this way. Of course you'd have to manipulate them separately in VFP, kinda of like we did with Date and Time before FP had a DateTime field type.
Rick
Rick
Mike Lewis
Programmer
revvinghigh,
What exactly is the problem? When you display in VFP a datetime field from a server that supports milliseconds, the milliseconds don't appear (do they?). Is there any reason why you can't just ignore them?
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
What exactly is the problem? When you display in VFP a datetime field from a server that supports milliseconds, the milliseconds don't appear (do they?). Is there any reason why you can't just ignore them?
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
- Status
Similar threads
